+ Reply to Thread
Results 1 to 5 of 5

Working code omend to take all used range in column

  1. 08-25-2014, 03:29 PM #1
    abjac
    abjac is offline
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Working code omend to take all used range in column

    HI Could some look at below code just need it to be able to take all used range in column N.

    I thought I could easily do that, but it always give an error. Please have a look.

    Thanks

    Sincerely
    Abjac

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 08-25-2014, 03:51 PM #2
    stnkynts
    stnkynts is offline
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Working code omend to take all used range in column 

    Please Login or Register  to view this content.
    Last edited by stnkynts; 08-25-2014 at 03:53 PM.
    Reply With QuoteRegister To Reply
  3. 08-25-2014, 03:59 PM #3
    abjac
    abjac is offline
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Working code omend to take all used range in column

    Hi stnkynts. That's works just great thanks allot

    Have a nice evening

    sincerely

    Abjac
    Reply With QuoteRegister To Reply
  4. 08-25-2014, 03:59 PM #4
    xladept
    xladept is offline
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Working code omend to take all used range in column

    Hi abjac,

    This works:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
    Reply With QuoteRegister To Reply
  5. 08-25-2014, 04:02 PM #5
    abjac
    abjac is offline
    Forum Contributor
    Join Date
    07-28-2012
    Location
    madrid
    MS-Off Ver
    Excel 2010 at work excel 2016
    Posts
    1,102

    Re: Working code omend to take all used range in column

    Hi Xladept. It take only cell N9 I need it to take all used range from N9 and down. But thanks allot for trying and help. Realy appreciate it. The other solution is working.

    Thanks allot

    Sincerely
    Abjac
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. The code for sum in column 'an' not working
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 04-19-2014, 09:33 AM
  2. [SOLVED] Omend code to include 2 rows above found row.
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-04-2013, 08:18 AM
  3. [SOLVED] Working code need inputbox for range
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2013, 06:52 AM
  4. [SOLVED] user form range not working in code
    By jed38 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 08-20-2012, 11:20 AM
  5. Subscript out of range error & code not working
    By HP RodNuclear in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 07-01-2011, 03:53 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1