Posted to microsoft.public.excel.programming

emil

external usenet poster

Posts: 49

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Expanding ranges in macros	Jeff	Excel Discussion (Misc queries)	4	January 5th 09 10:16 PM
Expanding selected data	veanmas	Charts and Charting in Excel	2	October 24th 08 10:44 PM
Expanding ranges causing probs?	Simon Lloyd[_672_]	Excel Programming	3	January 4th 06 03:04 PM
Expanding ranges after sort???	Simon Lloyd[_670_]	Excel Programming	2	January 1st 06 05:45 PM
named ranges - changing ranges with month selected	gr8guy	Excel Programming	2	May 28th 04 04:50 AM

All times are GMT +1. The time now is 12:29 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us