cdavidson

Posts: n/a

How to apply OFFSET as the range in a basic 'Copy' process...

Simply looking to understand how to properly apply the offset command to
identify a range in VBA coding. The respective portion of my 'improper' code
is shown below. What should the 'Range("...' line of code be? Thanks!

Sub PivotConcept()

Sheets("Pivots").Select
Range("(OFFSET(R12C8,7,6,3,2)").Select
Selection.Copy

..
..
..

End Sub

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
formula to copy last positive number in range of cells	rolan	Excel Worksheet Functions	6	May 14th 05 02:27 PM
Basic: Looking up Data in Range	JonZ	Excel Discussion (Misc queries)	8	December 31st 04 01:08 AM
Copy a range	GrantM	Excel Worksheet Functions	1	December 21st 04 09:59 AM
Define Range with an offset	GregR	Excel Discussion (Misc queries)	9	December 21st 04 07:22 AM
copy range of cells from one workbook to another	mitmeez	Excel Discussion (Misc queries)	1	December 9th 04 08:14 PM

All times are GMT +1. The time now is 03:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us