View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jeanluc.praz@gmail.com is offline
external usenet poster
 
Posts: 1
Default Create a sheet and name it

I need to write a macro which does the following

1) Create a new sheet in the current workbook

2) Scan the current sheet split each row into several columns and write
them in new sheet.

I know how to scan the current sheet but my problem is how, from the
current sheet, referer to the sheet I need to use to add rows. It is
not a copy row by row as sometimes several rows will make one row on
the new sheet