range properties 1

[Luis939]

is there a way i can find some properties of a range i define, such as
set myrange = workbooks("xxx&quot.worksheets("yyy&quot...

so that later on in my program if i just have myrange, can i find out what workbook and what worksheet it is in?
thanks!

 

[TonyJollans]

Hi Luis939,

myrange.Address(External:=True) gives you a complete [Workbook]Worksheet!Cells type address.

myrange.Worksheet.Name give you the sheet name.

and

myrange.Worksheet.Parent.Name should also give you the workbook name.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[Luis939]

Nice, thanks