Trouble with columns and for each
Experts:
Thanks a lot for your help
Regards,
Fernando Ortiz
"Fernando Ortiz" escribió en el mensaje
...
Hi Excel experts
I working on this code and i don't know why no run well.
I have a lot data in the Current region
Option Explicit
Sub Test()
Dim myrange As Range
Dim mycell As Range
Set myrange = Range("B2").CurrentRegion.Columns(1)
For Each mycell In myrange
mycell.Select
Next mycell
End Sub
Thanks for your expert advice
Regards
Fernando
|