Thread: [Solved] concatenate the currency too
View Single Post
 
Old 12-14-2015, 12:43 PM
charlesdh charlesdh is offline Windows 7 32bit Office 2010 32bit
Expert
  
Join Date: Apr 2014
Location: Mississippi
Posts: 382
charlesdh is on a distinguished road
Default
Hi,

I modified your code. Instead of using a "Array" I have the code look in column
G for blanks. The I joined the data from column A to E.
See code in "Mod1run" for sheet1. I remarked where I made a change. I remarked the code you had.
Attached Files
File Type: xlsm SAMPLE (5)-1.xlsm (117.4 KB, 17 views)
Reply With Quote