Thread: VB code to move text cell
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Len Len is offline
external usenet poster
  
Posts: 162
Default VB code to move text cell
Hi,


Is there anywhere to move existing text from cell B5 & C5 under Row 5
to a blank row immediately below the existing Row 5, say Row 11 is a
blank row immediately below Row 5 and the result will show the
existing text moved from cell B5 & C5 to cell B11 & C11 and this
process continues until it reaches the furnishing row ?

Please help to set a macro or VB code to perform the above process,
thanks


Regards
Len
Reply With QuoteReply With Quote