Hi I have a vba click button on sheet 2 which performs a simple delete row. However I'd like to move the button to sheet 1 but still make the vba perform the delete row on sheet 2.
Cheers
Dave
Hi I have a vba click button on sheet 2 which performs a simple delete row. However I'd like to move the button to sheet 1 but still make the vba perform the delete row on sheet 2.
Cheers
Dave
Hi
What's if you add in the first line of your code?
Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi it's coming up with syntax error, I've renamed sheet2 to B as that's the name of the sheet.
Sub Button3_Click()
sheets.("B").select
What's your (whole) code that you use?
Please Login or Register to view this content.
Perhaps
Please Login or Register to view this content.
Hi it comes up with another syntax error however I changed your original "sheets.("sheet2").select" to just Sheet2.select and that now works.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks