Strange problem with a macro

Question

Previous Topic Next Topic

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
Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
Run macro automatically when cell value changes ✓ - Forum - Excel
Macro to insert row in excel based on criteria ✓ - Forum - Excel
Usb files changed to strange symbols ✓ - 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

800
Oct 14, 2014 at 01:20 AM

check the sheet name (should be exact)

Strange problem with a macro

1 reply

Your reply

Subscribe To Our Newsletter!