View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pano[_3_] pano[_3_] is offline
external usenet poster
 
Posts: 30
Default Is this possible with a Macro

I want to check rows From T2 across to AA2 down to T37 across to AA37
on worksheet sheet1! If any of those rows have one or more cells that
have a number greater than 0.then

I want to then copy and paste the entire one or more rows to workSheet
1A! into the row area of E10 across to L10 down to E19 to L19. However
if none of the cells in a row have a number greater than zero dont'
copy....

Thats it in a nutshell.