Is it possible to set a variable range in a macro?
 

I get various downloaded reports out of SAP...I have a macro that does some formatting, analysis, etc....the problem I am having is that my downloads can vary in length...I have tried using the shift-end-arrow down as a keyboard function, but it marks the end of the range from the original source...

Also, is it possible to have a logical statement perform function? Let say: if a cell is blank, then delete it?

Thanks