Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Variable declared, set, so why is range failing?
Sub CopyCoVR2CtySht() Dim wbSource As Workbook Dim wsCoVR As Worksheet Dim lMosColCount As Long Dim lCtyRow As Long Dim lColStart As Long Dim wbCty As Workbook Dim sCty As String Set wbSource = ThisWorkbook Set wsCoVR = wbSource.Sheets("CoVR_ModelImportDataBOS proj") lColStart = 2 lCtyRow = 4 lMosColCount = 14 'start some kind of loop sCty = wsCoVR.Range("A" & lCtyRow) 'MsgBox sCty Workbooks.Add.Activate Set wbCty = ActiveWorkbook wbCty.SaveAs Filename:=ThisWorkbook.Path & "\" & sCty wsCoVR.Range(Cells(lCtyRow, lColStart), Cells(lCtyRow, lColStart + lMosColCount)).Copy <---RANGE FAILED Any suggestions? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
method 'range' of object'_global' failed | Excel Programming | |||
range method failed | Excel Programming | |||
method range failed | Excel Programming | |||
Range Question / error 1004: method Range of object Worksheet has failed | Excel Programming | |||
Method 'Range' of Object_Worksheet Failed | Excel Programming |