Hi, I recorded a macro to select a cell and highlight in grey. I tried to modify to select a random cell and highlight it but the WITH to highlight the selected cell fails. I can see the random cell being selected but the WITH fails with: Run-time eror '1004': Method 'Range' of object' _Global failed
Any help will be appreciated, thanks.
Please Login or Register to view this content.
Bookmarks