View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
esskaykay[_3_] esskaykay[_3_] is offline
external usenet poster
 
Posts: 1
Default Macro to edit cells


I’m trying to add a number and a hyphen (i.e., 123-) to the values i
all cells in a column. Under the old Lotus 123 DOS days, my macro cod
would read something like:

{edit}{home}123-{down}~

However, now with Excel, and VBA, I’m having a real problem do this.
Any ideas?

Thanks,
SK

--
esskayka
-----------------------------------------------------------------------
esskaykay's Profile: http://www.excelforum.com/member.php...nfo&userid=871
View this thread: http://www.excelforum.com/showthread.php?threadid=57011