Go to empty cell

**Sharp** · 06-19-2007, 10:27 AM

Hi,

does anyone know how to ensure that the first empty cell within column A is selected before the file is closed.

thanks

**sweep** · 06-19-2007, 10:37 AM

Hi,

This in the workbook section of your VBA project

Please Login or Register  to view this content.

**mudraker** · 06-19-2007, 05:46 PM

Here are a few diffent ways to find a vacant cell, row, column

Please Login or Register  to view this content.

To use in code

Please Login or Register  to view this content.

sweep

You are better off declaring your variable as Long which is more efficient than declarring it as varient

for more info read this page
http://www.cpearson.com/excel/variables.htm

**sweep** · 06-20-2007, 03:44 AM

Thanks Mudraker,

That's a bit of a mental block for me. I always go for integer for a loop variable, and when that returns an error, I change it to Variant.

Must remember long....must remember long...

**mudraker** · 06-20-2007, 07:34 AM

When dealing with an unknown number of rows in Excel I recommend always use Long never Integer

Go to empty cell

LinkBack

Thread Tools

Rate This Thread

Display

Go to empty cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions