Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time Error: '438'
Why doesn't this work:
For Each wb In Workbooks 'Test to see if wb's name is like "*C&A PF*.xlsm" If wb.Name Like "*C&A PF*.xlsm" Then With wb CDLastRow = .Sheets("Catalyst Dump").Range("A" & Rows.Count) _ & .End(xlUp).Row .Worksheets("Catalyst Dump").Columns("D").ColumnWidth = 18 End With End If Next The line starting with CDLastRow is giving me the error. Object doesn't support this property or method. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time Error: '438'
hi
try this syntax.. CDLastRow = .Sheets("Catalyst Dump").Range("A" & Rows.Count) _ .End(xlUp).Row basicily, loose the ampersand. regards FSt1 "Bishop" wrote: Why doesn't this work: For Each wb In Workbooks 'Test to see if wb's name is like "*C&A PF*.xlsm" If wb.Name Like "*C&A PF*.xlsm" Then With wb CDLastRow = .Sheets("Catalyst Dump").Range("A" & Rows.Count) _ & .End(xlUp).Row .Worksheets("Catalyst Dump").Columns("D").ColumnWidth = 18 End With End If Next The line starting with CDLastRow is giving me the error. Object doesn't support this property or method. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time Error: '438'
You're not concatenating a string he
CDLastRow = .Sheets("Catalyst Dump").Range("A" & Rows.Count) _ .End(xlUp).Row The space-underscore is the continuation character for extending one logical line of code to two physical lines. Bishop wrote: Why doesn't this work: For Each wb In Workbooks 'Test to see if wb's name is like "*C&A PF*.xlsm" If wb.Name Like "*C&A PF*.xlsm" Then With wb CDLastRow = .Sheets("Catalyst Dump").Range("A" & Rows.Count) _ & .End(xlUp).Row .Worksheets("Catalyst Dump").Columns("D").ColumnWidth = 18 End With End If Next The line starting with CDLastRow is giving me the error. Object doesn't support this property or method. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error handling error # 1004 Run-time error | Excel Programming | |||
Run time error '438'. Object doesn't support this property or meth | Excel Programming | |||
Run-time error '438': Object doesn't support this property of meth | Excel Programming | |||
run-time error '438' | Excel Programming | |||
error '438' | Excel Programming |