Results 1 to 3 of 3

VBA to allow selection of a Column Range

Threaded View

  1. #1
    Registered User
    Join Date
    11-21-2020
    Location
    Tamworth Australia
    MS-Off Ver
    2010
    Posts
    8

    VBA to allow selection of a Column Range

    Firstly as a complete VB novice I have so far floundered to this point with admirable aid from many others for which I am extremely grateful.
    Code does what I want with the Col E as currently default.

    I have one line of code Columns("E:E").Select and seek help to code so user can be given choice of columns. Range is E to BA.

    I have attached code which I acknowledge is rather clumsy as is a result of cut and paste plus trial and error. Content to remain as is but will certainly appreciate any suggestion
    At age 83 maybe should have stuck to COBOL.
    Attached Files Attached Files
    Last edited by 6StringJazzer; 12-18-2020 at 09:40 AM. Reason: No need to make the entire post bold

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to increase Range to More than One Column and remove error on multi selection?
    By mikedevt in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-09-2018, 04:52 PM
  2. [SOLVED] Defining Dynamic Selection Range in a Column
    By fpperryaz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-29-2016, 03:42 PM
  3. Column range selection
    By jeanleysg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2015, 09:47 AM
  4. Create a code for offsetting range selection by 1 column
    By amartino44 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2013, 12:56 PM
  5. Replies: 3
    Last Post: 07-24-2012, 10:35 AM
  6. cell selection in a given column range ?
    By cantabile in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-16-2007, 10:09 PM
  7. [SOLVED] Moving Range Selection Right One Column at a Time
    By TexDad in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-17-2005, 03:30 PM

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