It returns the location of where header is on the master sheet

it is a short hand method of saying

Set rng = Worksheets("Master").Range("A1:IV1").Item(1, ans)

so Item(1,ans) would be first row and nth column where nth is value of ans
for the Range starting in A1.


Worksheets("Master").Range("A1:IV1").Item(1, 1) is A1
Worksheets("Master").Range("A1:IV1").Item(1, 2) is B1
Worksheets("Master").Range("A1:IV1").Item(2, 1) is A2

for example.
--
Regards,
tom Ogilvy


"axg275 " wrote in message
...
Tom,

Thank you very much it worked great!

just one more question

what does this string mean so I know

Set rng = Worksheets("Master").Range("A1:IV1")(1, ans)

??


Thank you


---
Message posted from http://www.ExcelForum.com/