Thread: [Solved] Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow
View Single Post
 
Old 02-04-2017, 06:32 PM
FUGMAN FUGMAN is offline Windows 10 Office 2016
Banned
  
Join Date: Feb 2017
Posts: 55
FUGMAN is on a distinguished road
Default Clear all cell colors within a range starting at cell A8 and change row of active cell to yellow
I am looking for an Excel Macro that will do the following two tasks.

1. Clear all row colors within a range starting at cell A8 and ending at the last record in column A. The row of the last record in column A can be any row above row 8.

2. Then make the row of the active cell to be colored yellow.

Thanking you in advance for any help regarding this issue.
Reply With Quote