Results 1 to 5 of 5

Reference a Merged Cell Range in VBA

Threaded View

HangMan Reference a Merged Cell Range... 11-18-2015, 06:45 PM
Keebellah Re: Reference a Merged Cell... 11-18-2015, 06:54 PM
LeoTaxi Re: Reference a Merged Cell... 11-18-2015, 06:55 PM
HangMan Re: Reference a Merged Cell... 11-18-2015, 07:01 PM
jaslake Re: Reference a Merged Cell... 11-18-2015, 07:57 PM
  1. 11-18-2015, 06:45 PM #1
    HangMan is offline
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Reference a Merged Cell Range in VBA

    Is there any way to reference a merged cell range in VBA. I have cells B26:L29 merged and I'm looking for a way to reference these so that if rows 'above' the range are deleted, the code will still reconise the range, e.g. if rows 10 to 15 are deleted, the merged cells will then appear as B20:L23.

    Can this be done using a named range or is it simply not possible to do this? (sample attached).
    Attached Files Attached Files
    Thanks,
    HangMan

    You can say "Thank you!" by clicking Add Reputation below the post.
    Please, mark your thread [SOLVED] if you are happy with the solution.
    Reply With QuoteRegister To Reply
« 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. [SOLVED] VBA Code: how to use merged cell as range for a If and Formula statement
    By Acosta in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-04-2014, 03:12 PM
  2. Offsetting from a Cell within a Merged Range
    By exceere in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-04-2014, 12:45 AM
  3. [SOLVED] Value in a merged cell with a range name
    By dohzer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-12-2012, 07:20 AM
  4. VBA select cell range based upon the # of rows that make up a certain merged cell?
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-04-2012, 12:22 PM
  5. if find merged cell in a range change the reference sheet value to 0
    By farrukh in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2011, 07:41 AM
  6. User selected merged cell range to be cleared
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-06-2010, 11:21 PM
  7. Reference Merged Cell Value
    By AErmie in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-11-2009, 06:59 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