Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"Select Column method or property not available because some/all of object doesn't refer to table"
I'm attempting to write a macro which pastes Excel
cells into Word, and manipulates the formating. When I run the macro, even on the same table used to record the macro, I get: RunTime Error 4605 "Select Column method or property not available because some or all of object doesn't refer to table occurs." asterisked line causes the error (as indicated by a yellow arrow) : End With Selection.Tables(1).Select Selection.Columns.PreferredWidthType = wdPreferredWidthPoints Selection.Columns.PreferredWidth = InchesToPoints(0.92) Selection.Move Unit:=wdColumn, Count:=1 ** Selection.SelectColumn** Selection.Collapse Direction:=wdCollapseStart Selection.Move Unit:=wdColumn, Count:=-1 Selection.SelectColumn Selection.Collapse Direction:=wdCollapseStart Selection.Move Unit:=wdColumn, Count:=-1 Selection.SelectColumn Selection.Move Unit:=wdColumn, Count:=1 Selection.SelectColumn Any ideas? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"Object doesn't support this property or method" in Excel 2003 | Excel Discussion (Misc queries) | |||
"Select method of Range class failed" Error | Excel Discussion (Misc queries) | |||
"method 'execute' of object 'find' failed" | Excel Discussion (Misc queries) | |||
VBA error: "object doesn't support this property or method" | Excel Discussion (Misc queries) | |||
Run-time error "1004" Select method of range class failed | Excel Discussion (Misc queries) |