Thread: Help with an Excel macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Victor Delta[_2_] Victor Delta[_2_] is offline
external usenet poster
  
Posts: 199
Default Help with an Excel macro
"Sheeloo" wrote in message
...
Try
Sub macro()
Set ws = ThisWorkbook.Worksheets("Clients")
ws.Activate
rng = "W" & ws.Range("A100")
ws.Range(rng).Select
End Sub


Many thanks,

V

Reply With QuoteReply With Quote