Thread: using formuals
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hshayhorn hshayhorn is offline
external usenet poster
 
Posts: 16
Default using formuals

I have a repeating IF statement running down column A for 200 rows. I'm
making an assumption that I will not need more than 200 rows ever but I have
no idea how many rows I may need. My issue is thta because of the 200 rows
being used by the formula when I print the worksheet it prints all 200 rows
now just the rows that have real data. If there a way besides having the user
set the print area to only print rows with real data??