move to the cell on the right, my code not working pls help
I'll put some questions in the code
" wrote:
Hi
Pls assist me. Thank you.
My macro will move to the cell on the right when the current cell is
occupied & stop once it has been set to the new empty cell.
Sample of my data
A1 A2
C1 123
burner_cell is the cell containing 123
i have written some code to do this but i can't seems to get it to
work
my code =
Dim burner_cell As Range
Dim WS As Worksheet, WS2 As Worksheet
Dim counter As Integer
counter = 1
Set WS = Worksheets("Summary")
Set burner_cell = Range("B8")
While counter < 13
If Not (IsEmpty(burner_cell)) Then
burner_cell = burner_cell.Offset(0, 1) '<~~~do you want to reset the range name or reset the value in the range? THis resets the value in the range. If you want to reset the range name, you'll need to include SET before your statement
counter = counter + 1
End If
Wend
then i use burner_cell(new empty cell) to save the result of some
calculation
|