Hi,
I recorded this Macro and am encountering a Run-time error '424': Object required in the below code. Can anyone tell me what object I'm missing.
Any help is appreciated.Please Login or Register to view this content.
Thanks
Hi,
I recorded this Macro and am encountering a Run-time error '424': Object required in the below code. Can anyone tell me what object I'm missing.
Any help is appreciated.Please Login or Register to view this content.
Thanks
The missing object is probably the Sheet3 because that isn't the name of the new worksheet you added.
Change Sheet3 to ActiveSheet.
If posting code please use code tags, see here.
Worked without any problem for me as long as you have a tab named "Var"
If you found this helpful, click the star
Doesn't work for me when there's a sheet called 'Var' and the new sheet added has the codename Sheet6.
Thanks guys, I got it worked out. I was having a problem with renaming my sheets inside the Macro in the beginning.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks