Can I abbrevate the following (would I Dim and Set it as a Range?)

's Computer Specifications

AccRep.Sheets("Volumes").Cells.Find("latest")

Rather than using this many times in the code I thought I could define
it as a Rng or Path or String or something?

Which would I use, whats the different between a Path and a String.

Thanks VBA (virtually beginner amateur)

's Computer Specifications

hi, you can use Set to set a reference, e.g.

Dim rng as Range
Set rng = AccRep.Sheets("Volumes").Cells.find()
rng.offset(0,1)=1
rng.Offset(0,2)=2

rng must be a Range, a String won`t work.

stefan

On 18 Aug., 12:18, Simon <simonlaven...@gmail.com> wrote:
> AccRep.Sheets("Volumes").Cells.Find("latest")
>
> Rather than using this many times in the code I thought I could define
> it as a Rng or Path or String or something?
>
> Which would I use, whats the different between a Path and a String.
>
> Thanks VBA (virtually beginner amateur)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I enter formula sum(range+range)*0.15 sumif(range>=3)	tkw	Microsoft Excel Misc	2	1st Oct 2009 09:17 PM
subtracting a range from another range and getting a range result	cartoper@gmail.com	Microsoft Excel Discussion	4	3rd Feb 2007 05:47 PM
Excel Addin:Setting the range to the Excel.Range object range prop	=?Utf-8?B?UnAwMDc=?=	Microsoft Excel Worksheet Functions	5	24th Nov 2006 04:30 PM
Sum Range 1 when the elements in Range 2 are found in Range 3	james s shoenfelt	Microsoft Excel Misc	1	3rd Nov 2003 11:34 PM
how to? set my range= my UDF argument (range vs. value in range) [advanced?]	Keith R	Microsoft Excel Programming	2	11th Aug 2003 05:55 PM