A
Anika V. Bristalli
My apologies if this has already been addressed, but I could not quite
find the exact answer in the previous topics. I am trying to create a
macro that does the following:
* There is a user-selected range (R1)
* The macro goes through each cell in Column 3 of the selected range
(R1.Columns(3)), and checks if a cell is empty or not. If the cell is
empty, then the macro colors this cell plus the seven adjacent cells
to the right of it in grey.
* The macro terminates when it reaches the end of the selected range
R1.
I know the basic concepts, but seem to be missing something with
regards to syntax or something as I am fairly new to excel vba. So, I
would appreciate any suggestions as to how to properly code this
thing. Thank you!
find the exact answer in the previous topics. I am trying to create a
macro that does the following:
* There is a user-selected range (R1)
* The macro goes through each cell in Column 3 of the selected range
(R1.Columns(3)), and checks if a cell is empty or not. If the cell is
empty, then the macro colors this cell plus the seven adjacent cells
to the right of it in grey.
* The macro terminates when it reaches the end of the selected range
R1.
I know the basic concepts, but seem to be missing something with
regards to syntax or something as I am fairly new to excel vba. So, I
would appreciate any suggestions as to how to properly code this
thing. Thank you!