LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 107
Default Using a cell's contents as a reference in Macros

Hi -

I am new to both the group and any 'advanced' Excel Macros, and was
hoping someone more knowledgeable than myself could assist.

I KNOW there is a solution to the following problem but am having
trouble getting it just right.

I need to be able to copy the values in a range of cells to another
worksheet, but the destination range on that sheet is defined by a
cell, and the reference it contains will be different each time.

Bearing in mind my VBA knowledge is limited, how should I go about
doing this?

Any tips much appreciated.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Using cell's contents as an index to a row ...? Mac Excel Worksheet Functions 3 February 16th 09 12:59 AM
link to a cell's contents John Bundy Excel Worksheet Functions 1 November 30th 06 09:43 PM
link to a cell's contents bluezcruizer Excel Worksheet Functions 0 November 30th 06 03:55 PM
Rotate a box with a cell's contents Circe Excel Discussion (Misc queries) 6 February 3rd 05 11:45 PM
macro to use a cell's contents as it's name Stephen Simons Excel Programming 2 June 11th 04 08:49 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"