Carriage Returns

[fatz]

Help-

I have a macro to count rows in an excel spreadsheet. The code i am using is

If x <> &quot;&quot; then

and it keeps counting rows with out visible text.

Is there code to only count visible text or eliminate carriage returns.

Thanks for the help!

fatz

 

[SBendBuckeye]

Hello Fatz,

Intrinsic constants vbCr, vbLf, vbCrLf, vbNullString are the types of things you are asking about. Not sure what you are trying to do, but check out the SpecialCells property in help. It can count blank rows, data rows, etc. Good Luck!

Have a great day!

j2consulting@yahoo.com

 

[PHV]

Have you tried something like this ?

If Trim(x) > " " Then

Hope This Help
PH.