View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bourbon Bourbon is offline
external usenet poster
 
Posts: 1
Default Finding and Deleting last row


Hi, I'm learning VB and have a problem. It is very simple: I have
spread sheet for which I am writing a macro to 1) Delete the content
of the first row...this is done and then 2) find the last row wit
content and delete the content. I am having trouble writing the cod
for 2....

I have : lastrow.select
selection.clearcontents

Can anyone help?

Regard

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com