View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nordscan[_3_] nordscan[_3_] is offline
external usenet poster
 
Posts: 1
Default Copy, delete, print in one step


Hi all,

I have a question, if is this possible:

in worksheet3
copy D27 - D40 in B27 - B40
delete d27 - D40 the cells move left

print worksheet 1 -4x
print worksheet 2 -1x

and all this repeat unti D27 is empty /cca 140x/
Can 15sec. pause between repeat
thnx


--
nordscan
------------------------------------------------------------------------
nordscan's Profile: http://www.excelforum.com/member.php...o&userid=31136
View this thread: http://www.excelforum.com/showthread...hreadid=511006