View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Macro-Challenged Macro-Challenged is offline
external usenet poster
 
Posts: 1
Default how do I tell a macro to move to the bottom of a collumn plus one

Hello,

Im trying to write a simple macro that determines the bottom end of a
collumn of data, and then down drops down one more row to a blank space.
This would be useful for a situation when you want to tack on more info in a
collumn where you dont necessarily know where the previous list of data ends.

For example I know:

Selection.End(xlDown).Select

this will get me to the last item in a list of data, but not to the next
blank row

How do I tell it (in a macro) to skip down one more space?

Please email me at:

Thank you
Richard S