Results 1 to 12 of 12

select column based on cell input

Threaded View

jcfrancisco select column based on cell... 09-26-2011, 10:13 AM
JBeaucaire Re: select column based on... 09-26-2011, 11:10 AM
jcfrancisco Re: select column based on... 09-26-2011, 01:20 PM
JBeaucaire Re: select column based on... 09-27-2011, 01:34 AM
Mordred Re: select column based on... 09-27-2011, 01:59 AM
jcfrancisco Re: select column based on... 09-27-2011, 10:07 AM
JBeaucaire Re: select column based on... 09-27-2011, 11:02 AM
jcfrancisco Re: select column based on... 09-27-2011, 01:59 PM
JBeaucaire Re: select column based on... 09-27-2011, 08:24 PM
jcfrancisco Re: select column based on... 10-03-2011, 10:11 AM
JBeaucaire Re: select column based on... 10-03-2011, 06:31 PM
jcfrancisco Re: select column based on... 10-04-2011, 09:52 AM
  1. #1
    Registered User
    Join Date
    09-22-2011
    Location
    Buffalo
    MS-Off Ver
    Excel 2010
    Posts
    11

    select column based on cell input

    Hi, I have a macro that selects an entire column based on an input box.
    Macro2 Macro
    '
        Dim UserReply1 As String
        
        UserReply1 = InputBox("Enter column letter to hard code")
    
        Columns(UserReply1 & ":" & UserReply1).Select
        Selection.Copy
    I would like to change it so that it selects the entire column based on the value of 1 cell. ie ( Set up tab, cell A1). And then select that column for every worksheet in my workbook ( there's like 20 ). I appreciate any help. thanks.
    Last edited by jcfrancisco; 10-04-2011 at 09:48 AM.

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