asked on vba error_row & col hilite
hi experts the following code is giving me error when i have copied it from another wksht where it works perfectly to a new wksht then does not work & shows errors, see below.
.
vba code compile error_06.1.PNG
.
vba code compile error_06.1.PNG
VBA
Last Comment
Martin Liss
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thankyou bembi
ASKER
ive noticed now that i have copied the code into the module & then the other code also to hilite the row & columns, i have copied the code into another wksht in the same wkbk but it does not hilite the entire column only above the active cell, why is that? see attached screenshot.
vba-code-hilite-rows---columns_1.PNG
vba-code-hilite-rows---columns_1.PNG
Please attach the problem workbook.
ASKER
seems to be working now for some reason, thanks anyway martin
That's good.
The code relies on a sub / function which also resides in a module in the same workbook.
To make it work, copy both to the new workbook.