+ Reply to Thread
Results 1 to 11 of 11

Using LastCellBeforeBlankInColumnA to Make Range

  1. 04-09-2010, 12:37 PM #1
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Using LastCellBeforeBlankInColumnA to Make Range

    Hi all,

    I want to use the following line statement along
    Reply With QuoteRegister To Reply
  2. 04-09-2010, 12:44 PM #2
    contaminated
    contaminated is offline
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    D'u mean something like this

    Please Login or Register  to view this content.
    Люди, питающие благие намерения, как раз и становятся чудовищами.

    Regards, ?Born in USSR?
    Vusal M Dadashev
    Baku, Azerbaijan
    Reply With QuoteRegister To Reply
  3. 04-09-2010, 12:44 PM #3
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    I'd like to set a range from A25:G down to the LastCellBeforeBlankInColumnA


    Range("A25").End(xlDown).Select , will find the last cell in column A.
    I just need to include this somehow in a statement so my start range is A25
    and my end range is, ":G & Range("A25").End(xlDown).Select.row"



    Here are my attempts so far.


    Please Login or Register  to view this content.
    Last edited by bdb1974; 04-09-2010 at 12:49 PM.
    Reply With QuoteRegister To Reply
  4. 04-09-2010, 12:48 PM #4
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    Try on these lines maybe

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 04-09-2010, 12:56 PM #5
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    ok i've tried the following:
    Please Login or Register  to view this content.
    I'm getting:
    'Object variable or with block variable not set

    BDB
    Reply With QuoteRegister To Reply
  6. 04-09-2010, 12:59 PM #6
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    Sorry cant edit post and posts crossing

    Try
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 04-09-2010, 01:02 PM #7
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    This is what I wanted to post, but could not edit last one

    Sorry cant edit post and posts crossing

    Try
    Please Login or Register  to view this content.
    Problems with the forum site
    Reply With QuoteRegister To Reply
  8. 04-09-2010, 01:13 PM #8
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    Ok, I got it solved with your help Marcol.

    Here it goes:
    Please Login or Register  to view this content.
    Thanks a bundle,

    BDB
    Reply With QuoteRegister To Reply
  9. 04-09-2010, 01:16 PM #9
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    Yes, I ran into the same problem while posting this thread.

    Now, I can't even mark this thread "SOLVED".

    Thanks again.

    BDB
    Reply With QuoteRegister To Reply
  10. 04-09-2010, 01:30 PM #10
    Marcol
    Marcol is offline
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    Don't worry about it, but if you can find time sometime later to mark the post [Solved] it would keep things tidy,
    Maybe Admin will join in and help us clean up unintended posts!

    Glad to have been of some help.

    Alistair
    Reply With QuoteRegister To Reply
  11. 04-09-2010, 01:45 PM #11
    bdb1974
    bdb1974 is offline
    Forum Contributor
    Join Date
    12-10-2008
    Location
    Austin
    Posts
    660

    Re: Using LastCellBeforeBlankInColumnA to Make Range

    Thanks to Contaminated, actually it was your posted that I missed initially.
    It provided the fuel to light my fire.

    Thanks again to both.

    BDB
    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)

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