Hello!
I have a workbook, with several worksheets. The worksheets are named iex
Test 1
Test 2
Test 3
What I want to do is having the makro understand that if a new worksheet is generated, for example "Test 4", then this dimmed as the new variable which I use in reference in the following coding.
Is it possible?
Last edited by Hjahren; 09-28-2010 at 09:39 AM.
If the new sheet will always be the last one to the right on you tabs you can use:
Please Login or Register to view this content.
You would need to control how tabs are added to the workbook and protect the workbook structure. Another approach might be to loop through each worksheet and work out which one has the highest number.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
What following coding?
I have a macro which will use the sheet with the highest number, but there are also other worksheets that doesn't start with test.
The ideal would be that the macro selected or dimmed the worksheet with "Test ##" and the highest number.
Please Login or Register to view this content.
Something like:
Please Login or Register to view this content.Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
I got:
"Compile error:
Dupiclate declaration in current scope".
And it was when running the first line "wks as worksheet"
Then remove that part. You didn't post much code so I assumed you hadn't declared anything.
wks doesnt get a value, but the macro runs through the function you gave without a problem. I get "type mismatch" error at sheets(wks).Select
Where in my code does it say:
?Please Login or Register to view this content.
I believed that this sentence dimmed wks as the spreadsheetPlease Login or Register to view this content.
That's not what I'm asking. My code says:
notPlease Login or Register to view this content.
because wks is a worksheet, not the name of one.Please Login or Register to view this content.
Stupid me
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks