Can someone help me with a VB code that will find the last active cell in column "A" and then highlight accross in that particular row A:S (But only highlight the last active row)
Light gray (25%)
Thanks,
Can someone help me with a VB code that will find the last active cell in column "A" and then highlight accross in that particular row A:S (But only highlight the last active row)
Light gray (25%)
Thanks,
Don't know what your sheet looks like; but, an alternative is to use Conditional Formatting. Select the entire columns A to S and enter the formula:
Then apply your particular format.Please Login or Register to view this content.
Ben Van Johnson
In VB:
Change the Sheet to be whichever one you want.Please Login or Register to view this content.
Regards
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks