How to call Excel End function?

rorrison

I'm trying to select the cells in a column that have something in them. From various sources I have put together:

XlRange := XlWorkSheet.Range('B3').End(-4121);  // -4121 = xlDown

However, when I try to compile this I get the error

A field from a record variable was expected. For example
Record.Field
Customer.Name

with the cursor right before the E of End. I'm guessing that it's interpreting "End" as a keyword, and complaining that there's something missing after the dot.

Is there a way to call the End function on an automation object, or some other way to do what I want?

Thanks,

Randy

SPost29

Hi,
I haven't tried this but in the examples in excel help
Range("B4").End(xlToRight).Select
The Select is included
Have you tried?

XlRange := XlWorkSheet.Range('B3').End(-4121).Select;

rorrison

Yes, I started with that and removed the Select while trying to get it to work.