Hey!
Currently trying to create a macro for clearing multiple separate cell ranges.
I got a macro of a website, added my cell ranges and tried to specify that it would run only on the active sheet. But running it gives "Run-time error '438'". It looks like this:
Any ideas what is wrong?
Please Login or Register to view this content.
Last edited by Christianekstrom; 11-01-2021 at 12:00 PM.
Change this:
To either of these:Please Login or Register to view this content.
orPlease Login or Register to view this content.
WBDPlease Login or Register to view this content.
Office 365 on Windows 11, looking for ✶ rep!
This part doesn't make sense:
It's either:Please Login or Register to view this content.
to refer to the active sheet, or:Please Login or Register to view this content.
to refer to a sheet by name.Please Login or Register to view this content.
Rory
If you are setting the range for the active sheet, you don't need to say the workbook or sheet.
Please Login or Register to view this content.
Setting it to ".ActiveSheet ." gives the following msg: "Complie error: syntax error".
Setting it to ".Sheets("Clear Cell") ." gives the same error msg.
The app also highlights the line "Sub clearCellContentsKeepFormatting()" in yellow.
I'm really new to VBA :/
This worked, thanks alot!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks