Hello all,
I'm running into a compile error with the following code:
Basically, I'm trying to take cell d14 from my Chat Info sheet and place the information in the next available cell in column B on the B&P weekly sheet. There are several other cells I'm transferring, in a similar method, too. Some have formulas. Any way. Appreciate another pair of eyes.
thanks much!
I'm running into a compile error with the following code:
Code:
Sub Macro2()
With Worksheets("B&P Weekly")
lMaxRows = .Cells(.Rows.Count, "B").End(xlUp).Row
.Range("B" & lMaxRows + 1).Formula = "='" & Chat Info & "'!D14"
End With
End Sub
Basically, I'm trying to take cell d14 from my Chat Info sheet and place the information in the next available cell in column B on the B&P weekly sheet. There are several other cells I'm transferring, in a similar method, too. Some have formulas. Any way. Appreciate another pair of eyes.
thanks much!