Hi I have a problem I have searched on but could not find.
I have a spreadsheet where I want to format certain rows (which contain about 15 columns per row) only.
For instance, I have 100 rows that are pre-formatted and I want to choose cell A-20, run the macro and make that entire row dark blue and large font, and I want certain cells to have the same text color as the blue background to hide the text in certain cells in the row.
Then I want to do the same thing to row 30 my selecting A-30 and running the macro.
I created the Macro by formatting a row on the sheet but obviousy no matter what cell or row I run it from It formats the row in the original Macro.
I just need it to select the row that is active when I start the Macro.
Using either the first cell in a row or the row selector would be fine.
Here is my macro as-is
Please Login or Register to view this content.
Thanks for any help
Bookmarks