I get run-time error 1004, on this very simple code:
Tried lots, none works. Have no clue this time, what it might be. xl2016.![]()
Sheets("Beosztasok").Activate ActiveCell.Offset(1, 0).Select Rows("1:10").Select 'Here comes the error message.
I get run-time error 1004, on this very simple code:
Tried lots, none works. Have no clue this time, what it might be. xl2016.![]()
Sheets("Beosztasok").Activate ActiveCell.Offset(1, 0).Select Rows("1:10").Select 'Here comes the error message.
Regards,
Gabor
Protect trees.. maybe one day we need to climb back....
![]()
With Sheets("Beosztasok") .Activate .Rows("1:10").Select End With
Good Luck...
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the [★ Add Reputation] to left of post window...
Also....Add a comment if you like!!!!
And remember...Mark Thread as Solved...
Excel Forum Rocks!!!
It works for me although I don't see why this line of code is necessary:
It doesn't seem to serve any purpose.![]()
ActiveCell.Offset(1, 0).Select
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Hi,
in fact none is necessary as any good code at 99.999% does not need to select anything …
sorry, I got it wrong: the code was on a worksheet module.
As soon as I moved over to a module it started working...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks