Strange problem with a macro [Closed]

Question

Strange problem with a macro [Closed]

Report

slocumDoc

Posts: 1
Registration date: Monday October 13, 2014
Status: Member
Last seen: October 13, 2014

- Oct 13, 2014 at 12:49 PM
venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

- Oct 14, 2014 at 01:20 AM

Hi,

I've been using an Excel macro for some time that opens another spreadsheet, selects all of the cells, copies them, comes back to the .xlsm workbook, selects a different tab in the workbook and pastes the data.

I recently copied both the .xlsm and the .xlsx that it references to another machine, and now when it hits the line 'Sheets("Data"_.Select', I get a "Run-time error '9': Subscript out of range" message. The macro still works on the machine from which I copied the files.

Any ideas? Please.

Strange problem with a macro
Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
Run macro when cell changes to specific value - How-To - Excel
How to copy data from one excel workbook to another using macro - How-To - Excel
Flash drive files replaced with strange symbols and numbers ✓ - Forum - Viruses/Security

1 reply

Ask a question

venkat1926 · Answer 1 · 2014-10-14T01:20:29-0400

Answer 1 / 1

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

792
Oct 14, 2014 at 01:20 AM

check the sheet name (should be exact)

Strange problem with a macro [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!