View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Craig from MI Craig from MI is offline
external usenet poster
 
Posts: 1
Default Selecting and pasting to an empty cell

Dear Great Minds of Excel,

I'm trying to write a macro for exel to copy a row in one workshee
then paste it in another worksheet but in an empty cell right below th
previous paste.

For example:

Worksheet 1

1 2 3 4 <---Copy

worksheet 2

0 0 0 1
1 2 3 4 <--- Then paste below 0 0 0 1

I think I would use active offset but it is not working. Can anyon
help? Thank

--
Message posted from http://www.ExcelForum.com