Results 1 to 2 of 2

VBA Find Dynamic Range based on Cell Borders then combine to one cell

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    Adelaide Australia
    MS-Off Ver
    Excel 2013
    Posts
    5

    VBA Find Dynamic Range based on Cell Borders then combine to one cell

    Hi all reaching the limits of my VBA skills and would appreciate some guidance

    Here is my problem, in two parts

    1)
    I have a report which I am trying to extract data from.
    There are two sections (Notes A & Notes B in the sample workbook) which always start at the same range, but could be any number of rows down.

    I figured that using the border formatting between the notes would be the easiest way to define the range, but I don't know how to code it.

    (I have named the ranges in my sample file purely to make it easy to see which data i am trying to extract)

    2)
    Once the range is defined, I then need to copy the range values into one cell, line breaks in tact.

    That is, to give the same result as this code:
    Dim NotesB As String
    
    NotesB = Range("C12") & vbCrLf & Range("C13") & vbCrLf & Range("C14") & vbCrLf & Range("C15")
    
    Range("c20").Value = NotesB
    Thanks, Ivan
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find Cell Value from range Cell value is dynamic variabl
    By dhaval123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-31-2014, 01:44 PM
  2. [SOLVED] Adjust Multiple Cell Borders Based on Cell Contents
    By USFishin in forum Excel General
    Replies: 16
    Last Post: 04-10-2012, 12:56 AM
  3. Dynamic Range - Cell borders
    By PRodgers4284 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-31-2009, 07:36 AM
  4. Find Last Cell In range, and changing another Cell based on offset text
    By radar_jynx in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-05-2009, 04:52 AM
  5. copying dynamic range based on cell outside of range
    By xcelelder in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2005, 12:08 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