Frank .S
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.