move this rectangle to hide the unused cells

  • Thread starter Thread starter ~Alan Rosenberg Miami
  • Start date Start date
A

~Alan Rosenberg Miami

Xl2000
I have 90 rows with formulas that are not being used yet and I don't
want to see them untill I need them.
Each work day that is monday through friday I will use the next 2 rows.
So what I created a Rectangle colored white to hide the unused cells
and I have a macro that I click on to move the Rectangle 2 rows
Question Is it possible to have XL move this rectangle each work day
when I open this sheet
and not move it on the weekends when I may want to review
the sheet
Sub Rectangle10_Click()
ActiveSheet.Shapes("Rectangle 9").Select
Selection.ShapeRange.IncrementTop 24.75
End Sub
 
Why not just design the formulas so the cells look blank when there is no
entry in a specified cell in the row

in B30 as an example
=if(A30="","",currentformula)

So when I enter something in column A of that row (row 30),
then the formula calculates as designed, otherwise, the cell looks blank.

Regards,
Tom Ogilvy
 
Back
Top