Last Active Cell

[Brian]

I have a template created that pulls information from
different worksheets. I would like to be able to add "End
of Report" to the bottom of the report. I have visited
different websites and found how to find the last active
cell but it does not work for me because of formulas that
were written in the cells. I tried to copy and paste
special, but I still end up going beyond where the last
cell actually is. For example in column A1 I have
='Sheet1'!A1. Now I have this copied down to A100. If I
end up only going to A50, my last active cell formula
still takes me to A100. Can this be fixed? TIA

 

[Frank Isaacs]

I think if the data covers only one page, your best bet is to use the
footer.

Otherwise, you'd probably have to use an IF statement around your data down
to A100, so that it would put "END" if it would otherwise be blank (AND the
cell above it doesn't already have "END" in it).
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com