Hello,
Is there a method similar to
I have a formula in B3, I used the above to copy the formula down to the last row. I would now like to copy right to the last column based on row 2.
Basically trying to fill a range last row and last column with the formula in B3.
A is used for the last row
2 is used for the last column
Thank you
Is there a method similar to
Range("B4:B" & Range("A" & Rows.Count).End(xlUp).Row)
that can be used for columns?I have a formula in B3, I used the above to copy the formula down to the last row. I would now like to copy right to the last column based on row 2.
Basically trying to fill a range last row and last column with the formula in B3.
A is used for the last row
2 is used for the last column
Thank you