Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Set Active Sheet as Variable
Sub FirstMoveToQuoteSheet()
Dim QuoteSht As Worksheet Dim Log As Worksheet Dim Opn As String Set QuoteSht = AvtiveSheet Opn = "G:\New Items\Tracking Lists\" & QuoteSht.Range("R15") = _ Left(QuoteSht.Range("H2"), 2) & " Quotation Tracking Log.xls" MsgBox QuoteSht Workbooks.Open Filename:=Opn End Sub Here is the code. It bugs out on msgbox. The Quotesheet is set to nothing. any help would be greatly appreciated. Thanks, Jay |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy sheet and make new sheet active | Excel Discussion (Misc queries) | |||
Set a variable to the active cell | Excel Discussion (Misc queries) | |||
Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
Using the Active cell in one sheet for another sheet | Excel Discussion (Misc queries) |