« Unique Values Advanced Filter
Prioritize List on a Worksheet »

xlColumnWidths Bug

13th June 2005, 06:43 pm by Dick Kusleika

Mike asks

...But when you try to do Selection.PasteSpecial Paste:=xlColumnWidths and try to run the macro, Excel say xlColumnWidths is undefined. Strange, since this is what the macro recorder gave me. ...

I can honestly say that I've never pasted special column widths before. In fact, I didn't even know it was an option. But Mike did indeed discover a bug that MS describes in KB231090. When I recorded a macro, I got

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 6/13/2005 by Dick Kusleika
'

'
    Selection.Copy
    Range("E1").Select
    Selection.PasteSpecial Paste:=xlcolumnwidths, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
End Sub

But it looks like the Excel guys forgot to create the constant xlColumnWidths. Use it's intended literal value, 8, instead, e.g.

Selection.PasteSpecial Paste:=8

Category: Bugs  |  Comment (RSS)  |  Trackback

One Comment

  1. Ron de Bruin:

    Hi all

    There is also a problem if you use xlPasteValidation

    Use 6 then

    16 June 2005, 1:18 pm

Certain comments are subject to moderation and may not appear immediately. You can use HTML tags in your comment. If you include a greater-than or less-than sign or anything else that could be interpreted as HTML, your comment won't look nice. You need to escape those characters. To post VBA code in your comment, use [VB] tags, like this: [VB]Code goes here[/VB].

Leave a comment