Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Active Sheet
I've got the worksheet and cell hard-coded below. What's the syntax to
replace "sheet1" withe name of the active worksheet and replace "a7" with the active cell? I'd like to be able to assign both above mentioned values to variables like "pageActive" and "cellActive" and then be able to insert those variables into the code below. I'm familiar with Access VBA, but don't know how to treat Excel's vba variables and quotes. CODE: Worksheets("sheet1").Range("a7").Value |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Active Sheet
I'm not just 100% sure what you want but here goes
dim strActiveSheet as String dim strActiveCell as String strActiveSheet = ActiveSheet.Name strActiveCell = ActiveCell.Address Worksheets(strActiveSheet).Range(strActiveCell).Va lue -- HTH... Jim Thomlinson "scott" wrote: I've got the worksheet and cell hard-coded below. What's the syntax to replace "sheet1" withe name of the active worksheet and replace "a7" with the active cell? I'd like to be able to assign both above mentioned values to variables like "pageActive" and "cellActive" and then be able to insert those variables into the code below. I'm familiar with Access VBA, but don't know how to treat Excel's vba variables and quotes. CODE: Worksheets("sheet1").Range("a7").Value |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Get Active Sheet
that get's it.
"Jim Thomlinson" wrote in message ... I'm not just 100% sure what you want but here goes dim strActiveSheet as String dim strActiveCell as String strActiveSheet = ActiveSheet.Name strActiveCell = ActiveCell.Address Worksheets(strActiveSheet).Range(strActiveCell).Va lue -- HTH... Jim Thomlinson "scott" wrote: I've got the worksheet and cell hard-coded below. What's the syntax to replace "sheet1" withe name of the active worksheet and replace "a7" with the active cell? I'd like to be able to assign both above mentioned values to variables like "pageActive" and "cellActive" and then be able to insert those variables into the code below. I'm familiar with Access VBA, but don't know how to treat Excel's vba variables and quotes. CODE: Worksheets("sheet1").Range("a7").Value |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I need to sort an active sheet using the col of the active cell | Excel Programming | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
Copy my active sheet to a new sheet and open with an input form | Excel Programming | |||
Copy from active sheet and paste into new sheet using info from cell in active | Excel Programming | |||
Calculate active sheet on sheet selection | Excel Programming |