Posted to microsoft.public.excel.programming

external usenet poster

Posts: 3

Macro - relative end of data

I want to create a macro that looks for the last ROW of data (which will
always vary) and allows me to copy and paste columns of real data between
spreadsheets. When I RECORD a macro to study the code, it always gives me an
absolute cell reference. How can I modify that macro to point to the
relative end of data? Thanks!

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
The Relative Macro	DanP	Excel Discussion (Misc queries)	6	March 17th 09 02:58 PM
relative value in macro	Janett	Excel Discussion (Misc queries)	2	April 4th 06 05:42 PM
Relative Reference in a Macro	DRH	Excel Programming	2	December 31st 04 02:20 PM
MACRO Relative Reference	Ibrahim Awwad	Excel Programming	3	September 9th 03 02:11 PM
relative ref. macro	J.E. McGimpsey	Excel Programming	0	July 28th 03 05:03 PM

All times are GMT +1. The time now is 07:29 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us