Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Names of worksheets
Hi all,
I am using a set of excel sheets to do some costing. Because I have multiple sheets ( changes every project ) I was hoping to write some code to copy the fields from each sheet ( let just say A3 ) to the final costing sheet. To do this I thought about assigning a variable to the name of each sheet and using the variable to wite the formula. Unfortunately I have trouble with the assigning of the variable to the sheet name. I started with something similar to this For i = 1 To Worksheets.Count tmpName = "sheets" & i SName = Worksheets(tmpName).Name does a) anybody understand my problem and b) can anyone help Thanks in Advance MM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum accross worksheets using names | Excel Worksheet Functions | |||
same range names in different worksheets | Excel Worksheet Functions | |||
names in different worksheets | Excel Worksheet Functions | |||
Compare names on two worksheets | New Users to Excel | |||
Names and Separate Worksheets | Excel Worksheet Functions |