MrExcel Publishing
Your One Stop for Excel Tips & Solutions

using VB for Excel

Posted by Brian on June 26, 2001 6:55 PM

hi all

basically i have added a form to input information into a worksheet.

I'm trying to make add so that when i click the "OK" command button, I have on my form, it will add the info to the last row in the spreadsheet that does not contain text.

basically I'm not sure how to create an IF statement that will test to see if a cell contains text.

so heres the logic:

IF sell contains text go to the next cell


I apologise if some1 has already asked this question, but after a quick scan i cant see anything relating to what I need to know


Posted by Kevin James on June 26, 2001 9:43 PM

Hi Brian,

Take a look at xlBottom


Posted by brian on June 26, 2001 10:03 PM

ok cheers m8 :)