Thread: Expanding selected ranges that are changing next time (with vba).
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
emil emil is offline
external usenet poster
  
Posts: 49
Default Expanding selected ranges that are changing next time (with vba).
Hi
Can someone help me?
In
e. g.Range ("G1:G700")
I am selected
e. g. Range ("G3:G5") .Select
and I expanded this selection with €śOffset€ť function
e. g. ActiveCell.Range("A1:A3").Select
ActiveCell.Offset(11, 0).Range("A1:D3").Select
Selection.Copy
It is OK, but next time I have other selected range
e. g. Range ("G20:G30") and the precedent €śOffset€ť is not OK.
What can I do?
Thanks for your time.
Emil

Reply With QuoteReply With Quote