prob. running macro from diff. sheet
I have this line in my macro:
Worksheets("ABC").Columns("A:A").Select If I run this macro when I am in a different sheet, it gives the run-time error 1004. How can I avoid this? What is the reason? Thx in advance. |
prob. running macro from diff. sheet
sorry, the answer is activating the sheet before that line:
Sheets("ABC").Activate i did the search but with "sheeeet" in the search-box, sorry :) "darxoul" wrote: I have this line in my macro: Worksheets("ABC").Columns("A:A").Select If I run this macro when I am in a different sheet, it gives the run-time error 1004. How can I avoid this? What is the reason? Thx in advance. |
All times are GMT +1. The time now is 08:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com