im trying to move data in A5:O5 down a row and then enter new data in one of my worksheets however im getting select method of range class failed error
please suggest an edit to this code
Please Login or Register to view this content.
im trying to move data in A5:O5 down a row and then enter new data in one of my worksheets however im getting select method of range class failed error
please suggest an edit to this code
Please Login or Register to view this content.
Hi Chelsea19,
Typically this will happen if you try to select a range on a sheet that isn't active. Try adding a line above the select statement to activate the sheet first:
Or if you don't want to activate it:Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by Arkadi; 01-08-2019 at 08:52 AM.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Please Login or Register to view this content.
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 star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks