Posted to microsoft.public.excel.programming

sonu[_2_]

external usenet poster

Posts: 31

end command not working

I want to control Excel from MS access. I created exapp object.
everyting woks right but I can use this following command. Any help is
really appreciated.

for each wks in exApp.worksheets
lstcolumn = exApp.worksheets(wks.name).Range("A65536").end(xlu p).row

next

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
SUM command not working	Craig	Excel Worksheet Functions	1	November 22nd 06 05:09 PM
Working on FindPrevious command in a userform	excelnut1954	Excel Programming	3	March 2nd 06 04:32 AM
ChangeLink Command Not Working	Dina	Excel Programming	8	February 17th 06 03:55 AM
command button isn't working	Nydia	New Users to Excel	1	April 29th 05 10:31 PM
Kill command not working	Larry Wood	Excel Programming	1	May 15th 04 02:06 PM

All times are GMT +1. The time now is 08:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us