Does anybody know how to create the fill effect on Column B starting at cell 2 and going until there are no more values left in Column A in a macro.
Does anybody know how to create the fill effect on Column B starting at cell 2 and going until there are no more values left in Column A in a macro.
Did you want column B, column A, or both? This is set up for column A and the color Red.
![]()
Please Login or Register to view this content.
Sorry I should of explained it better. It will be for column B. And i'm trying to autofill a formula that starts in B2 and will need to go until there are no more values left in Column A.
A slight modification too stnkynts' code.
![]()
Please Login or Register to view this content.
Hi, trevor2524,
maybe
Ciao,![]()
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks