mmopulencia
New Member
- Joined
- Feb 19, 2013
- Messages
- 30
Hello
I'm trying to do some cell referencing range like this one.
Sheets("IDNUMBER").Select
IDNEW = Sheet5.Range("A1")
now the challenge is, since ill be creating sheets as i go the Sheet number wont be constant. so i made a sheet to house all my sheetname and their corresponding number.
Sheets("SHEETNUMBERDB").Select (select the above sheet)
Sheetrangefordb = Range("C7").Value (i have an empty row 1, so this should output "sheet6")
now heres the things i tried
Sheetnumberdbrangefinder1 = Sheetrangefordb.Range("B1")
(this doesnt work)
Sheetnumberdbrangefinder1 = Sheetrangefordb & ".Range(""B1"")"
(this kinda works but instead of making at formula, it just outputs everything as a string "Sheet6.Range("B1")
so to cut it short i guess, I just want to be able to reference the Sheet number so itll out put Sheet6.Range("B1") , With Sheet6 as a non constant value.
Thank you in advance
I'm trying to do some cell referencing range like this one.
Sheets("IDNUMBER").Select
IDNEW = Sheet5.Range("A1")
now the challenge is, since ill be creating sheets as i go the Sheet number wont be constant. so i made a sheet to house all my sheetname and their corresponding number.
START UP (these are the actual Sheetname) | 1 | Sheet1 (sheet numbers) |
Registration | 2 | Sheet2 |
Evaluation | 3 | Sheet3 |
Update | 4 | Sheet4 |
IDNUMBER | 5 | Sheet5 |
SHEETNUMBERDB | 6 | Sheet6 |
Sheets("SHEETNUMBERDB").Select (select the above sheet)
Sheetrangefordb = Range("C7").Value (i have an empty row 1, so this should output "sheet6")
now heres the things i tried
Sheetnumberdbrangefinder1 = Sheetrangefordb.Range("B1")
(this doesnt work)
Sheetnumberdbrangefinder1 = Sheetrangefordb & ".Range(""B1"")"
(this kinda works but instead of making at formula, it just outputs everything as a string "Sheet6.Range("B1")
so to cut it short i guess, I just want to be able to reference the Sheet number so itll out put Sheet6.Range("B1") , With Sheet6 as a non constant value.
Thank you in advance