General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Jason,
Has your code created an excel object, open a workbook and referenced a sheet?
"xlToRight" and "xlDown" have worked for me. If you have excel visible, at this point you should see the cursur in cell B2.
>>with objsheet
>> .Range("A1").Select
>> .Selection.End(xlToRight).Select
>> .Selection.End(xlDown).Select
>>endwith
>
>Umm, I haven't used that command, sometimes you have to play with them, unless someone else can chime in with help. It looks like maybe too many Selects, is my first thought...you might try something like
>
>.Selection.End = xlToRight
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only