workbook

[priya_anthony]

Hi
can anyone help me of how to clear the existing contents of a sheet at workbook load event
and how to get the current row no

 

[Peter_SSs]

Hi
can anyone help me of how to clear the existing contents of a sheet at workbook load event

Try this, inserting the correct sheet name in place of abc

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_Open()
    Sheets("abc").Cells.ClearContents
<SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

.. and how to get the current row no

Can you explain exactly what you mean by this and which sheet you are referring to?

 

[priya_anthony]

Thanks Peter
It did work