I want VBA to enter a string of text into a cell with a changing row value for one example is this:
Sheets("Data Entry").Range("B" & CurrentRow1).Value = "=TEXT(RIGHT('Data Entry'!Q" & CurrentRow2 & ",8),8)"
Please tell me what needs to be correct. I want to be able to change text in a cell
Thank You In Advance
Sheets("Data Entry").Range("B" & CurrentRow1).Value = "=TEXT(RIGHT('Data Entry'!Q" & CurrentRow2 & ",8),8)"
Please tell me what needs to be correct. I want to be able to change text in a cell
Thank You In Advance