Results 1 to 2 of 2

VBA columns thorowing "wrong number of arguments or invalid property assignment" error

Threaded View

scantron VBA columns thorowing "wrong... 06-07-2012, 10:42 AM
scantron Re: VBA columns thorowing ... 06-07-2012, 11:38 AM
  1. #1
    Registered User
    Join Date
    01-20-2012
    Location
    New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    30

    VBA columns thorowing "wrong number of arguments or invalid property assignment" error

    So I'm just trying to do a quick formatting macro, Iused the macro recorder and upon trying to play it back it broke! Hrumph.

    columns("I:AL").Select
    (and many commands like it) throw an error (wrong number of arguments or invalid property assignment)

    The macro name is NOT columns or anything else that might be protected.

    This version throws the same errors.
    Sub BFormatting()
    columns("C:H").ColumnWidth = 3.71
    End Sub
    Last edited by scantron; 06-07-2012 at 10:49 AM. Reason: edited to show there is nothing fancy going on the error occurs even in the most stripped down version

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1