Try this... !!
Sub Test()
Range("B2").Select
Do
If ActiveCell.Value = "" Then Exit Do
ActiveCell.Offset(0, 3).Activate
Loop
End Sub
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, For
tware
> dguille...@gmail.com
>
> From: hemal shah
> Sent: Wednesday, December 14, 2011 6:24 AM
> To: excel-macros@googlegroups.com
> Subject: $$Excel-Macros$$ Cell editing VBA
>
> Question : In attached excel sheet, there are columns named "GRN" and "Recd
> Qty"
..@gmail.com
From: hemal shah
Sent: Wednesday, December 14, 2011 6:24 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Cell editing VBA
Question : In attached excel sheet, there are columns named "GRN" and "Recd
Qty"".
I want VBA code for Reced Qty col
Question : In attached excel sheet, there are columns named "GRN" and
"Recd Qty"".
I want VBA code for Reced Qty column's cell .. as soon as GRN cell is
filled Recd Qty's cell is activatied, else no..
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread