View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Fernando Ortiz Fernando Ortiz is offline
external usenet poster
 
Posts: 15
Default 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