Thread: Write a macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dasmithjones dasmithjones is offline
external usenet poster
 
Posts: 4
Default Write a macro

write macro that copies any numbers in a cell & appends those numbers
proceeded by a "." to the contents of another cell, same row?

example:

r1c1 r1c2

Boxholder PO Boxholder 123

the macro would copie the number value of r1c2 (123) and append the contents
of r1c1 preceded by a period.

Results desired:

Boxholder.123 PO Boxholder 123

Macro would have a control+c shortcut and would execute only once for the
selected row.

Thanks,


--
DASJ