Results 1 to 4 of 4

Thread: Fetch values from merged cells in macro

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 11-20-2013, 02:49 PM #3
    princ_wns
    princ_wns is offline
    Member
    Join Date
    Nov 2011
    Posts
    41
    Rep Power
    0
    let say you have a merge cells A1:C1 then for extracting the data from this you can code it like this.

    Code:
    range("A1:C1").areas(1).cells(1,1)

    Regards
    Prince
    Last edited by bakerman; 11-20-2013 at 03:27 PM. Reason: codetags added
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Excel Macro to populate the values in the required cells
    By pbabu in forum Excel Help
    Replies: 10
    Last Post: 11-21-2013, 04:41 PM
  2. Macro to fetch csv file and edit the file
    By dhivya.enjoy in forum Excel Help
    Replies: 6
    Last Post: 10-23-2013, 01:00 PM
  3. Macro to fetch csv files
    By dhivya.enjoy in forum Excel Help
    Replies: 2
    Last Post: 10-21-2013, 05:44 PM
  4. Fetch multiple values based on criteria
    By Lucero in forum Excel Help
    Replies: 8
    Last Post: 04-07-2012, 12:35 PM
  5. Find Merged Cells VBA
    By Admin in forum Excel and VBA Tips and Tricks
    Replies: 4
    Last Post: 02-25-2012, 03:07 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