I am after some VBA help.
I would like to copy the formula in B2:D2 down to the last Row where Column A is populated. Column A will be continually added to.
Any help much appreciated
I am after some VBA help.
I would like to copy the formula in B2:D2 down to the last Row where Column A is populated. Column A will be continually added to.
Any help much appreciated
Last edited by littlefoot; 03-31-2022 at 09:25 AM.
Sub J3v16() With Range("B2:D" & Cells(Rows.Count, 1).End(xlUp).Row) .Formula = "=IF(ISNUMBER(SEARCH(B$1,$A2)),B$1,"""")" End With End Sub
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Excellent. Thank you
Glad I could help...Tx for rep +
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks