Re: $$Excel-Macros$$ Query in For Each Next

Thanks Sir. On Wed, Jul 3, 2013 at 10:52 AM, Vabs VBA v...@vabs.in wrote: Hi X refer to each cell in range A1 to D5. Thanks On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All, Good Morning.. I got below macro from net ..Can you explain me what x stand

$$Excel-Macros$$ Query in For Each Next

Dear All, Good Morning.. I got below macro from net ..Can you explain me what x stand here... *Sub Upper_()* *For Each x In Range(A1:D5)* *'For Each x In Range(A1:D5)* * * *x.Value = UCase(x.Value)* *'x.Value = UCase(x.Value)* * * *Next* * * *Thanks in Advance.* *Regards,* *Prafull Jadhav.*

Re: $$Excel-Macros$$ Query in For Each Next

Hi X refer to each cell in range A1 to D5. Thanks On 3 Jul 2013 10:41, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear All, Good Morning.. I got below macro from net ..Can you explain me what x stand here... *Sub Upper_()* *For Each x In Range(A1:D5)* *'For Each x In