+ Reply to Thread
Results 1 to 4 of 4

Concatenate by macros

  1. 03-31-2009, 05:34 AM #1
    teodormircea
    teodormircea is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    29

    Exclamation Concatenate by macros

    Hello forum,

    I want to replace this formula by macros , = "*"& cell& "*"
    I've made this code but i'm doing it wrong ,
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 03-31-2009, 07:27 AM #2
    MickG
    MickG is offline
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Concatenate by macros

    Hi, Try this, if it's not exactly what you want, it should point you in the right direction.
    Please Login or Register  to view this content.
    Regards Mick
    Reply With QuoteRegister To Reply
  3. 03-31-2009, 07:30 AM #3
    teodormircea
    teodormircea is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    29

    Re: Concatenate by macros

    Thanks is working. but in case the source column is filter it should mark only the visible cells, how to do it, ah yes i forgot, it should mark till last row -1 because i have subtotal there
    Last edited by teodormircea; 03-31-2009 at 07:35 AM.
    Reply With QuoteRegister To Reply
  4. 03-31-2009, 08:13 AM #4
    teodormircea
    teodormircea is offline
    Registered User
    Join Date
    02-25-2008
    Posts
    29

    Re: Concatenate by macros

    Done it
    Please Login or Register  to view this content.
    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