Results 1 to 10 of 10

Selecting range using .range. But can you do same selection using .columns

Threaded View

welchs101 Selecting range using .range.... 07-01-2011, 09:20 AM
welchs101 Re: Selecting range using... 07-01-2011, 09:27 AM
welchs101 Re: Selecting range using... 07-01-2011, 09:35 AM
welchs101 Re: Selecting range using... 07-01-2011, 09:35 AM
romperstomper Re: Selecting range using... 07-01-2011, 09:34 AM
romperstomper Re: Selecting range using... 07-01-2011, 09:38 AM
royUK Re: Selecting range using... 07-01-2011, 09:39 AM
welchs101 Re: Selecting range using... 07-01-2011, 09:44 AM
romperstomper Re: Selecting range using... 07-01-2011, 09:48 AM
welchs101 Re: Selecting range using... 07-01-2011, 01:31 PM
  1. #1
    Forum Contributor
    Join Date
    12-01-2007
    Location
    USA-North Carolina
    MS-Off Ver
    MS Office 2016
    Posts
    2,712

    Selecting range using .range. But can you do same selection using .columns

    I know how to select a range of cells using code similar to the following:

    Set myinputfile = Workbooks("Dav_16Jun2011.xlsx").Worksheets("Sheet1")
    myinputfile.Range("A1:A" & alphacol(lst_row)).Select
    i have a function called alphacol which converts lst_row number to character equivalent.

    What i was wondering is .......is there a way to select range using the .columns

    I know i can select individual cells using .columns ....such as

    myinputfile.Columns(lst_row, 1).Select
    But i dont know how to select a range using the column method.
    Last edited by welchs101; 07-01-2011 at 01:38 PM.

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