Apparently blank cells in Excel have a numeric number.
What is the value as I would like to identify the first blanlk cell in a column?

How do I identify a blank cell?

Thanks
smiler44

Apparently blank cells in Excel have a numeric number.
What is the value as I would like to identify the first blanlk cell in a column?

How do I identify a blank cell?

Thanks
smiler44

I am not sure what you are referring to by "Numeric Number", but the Built-In Function IsBlank() can tell you whether a Cell is blank

Unfortunetely IsBlank is a misnomer, it actually checks for empty cells, ie a cell that has never had data or has had all data deleted. To check for a blank you use =" "

Brian

I use this in an automation routine as it goes down the spreadsheet:

If Len(.Cells(R, 1)) > 0 Then

Where R is a variable containing the row and 1 is column A.

I modified if Len(.Cells(orig, 1)) > 0 then


to Do Until Len(.Cells(orig, 1)) > 0

I get an error message "complie error invalid or unqualified reference" and it seems to be pointing to .cells as the problem

smiler44

In my case there had been a previous With started with the Excel variable (I was manipulating Excel from Access). You'd have to modify that as appropriate to your code.