Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveSheet.name not returning Sheet1, Sheet2
In VBE in the property window of a worksheet there is a field (Name) that
doesn't change even if the tab name or index position changes. I would like to use this "name" and evaluate it to reset the print range. I only want to reset the print range of Sheets "Sheet11" to "Sheet31". When I use the ActiveSheet.Name command I only get the "tab" name, not this static name. Is there any way to retrieve the (Name) and evaluate it. Here is the piece of code that I am working with. Dim SheetNum_Low As Integer Dim SheetNum_High As Integer Dim ws As Worksheet Dim SheetNum As Integer SheetNum_Low = 11 SheetNum_High = 31 For Each ws In Worksheets ws.Activate SheetNum = ActiveSheet.Index SheetNum = val(left(ActiveSheet.Name,2)) If SheetNum = SheetNum_Low And SheetNum <= SheetNum_High Then ActiveSheet.PageSetup.PrintArea = ActiveSheet.UsedRange.Address End If Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy data from sheet2 to sheet1 when sheet2 has variable # of rows | Excel Discussion (Misc queries) | |||
A1 Sheet2 is linked to A1 sheet1 so that user enters value(abc123) a1 sheet1 and A1 sheet2 is updated | Excel Programming | |||
how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
[=Sheet1!A1] - if i use Column A1 ('Sheet1') / A2 ('Sheet2') | Excel Worksheet Functions | |||
go to sheet1 to sheet2 | Excel Programming |