Posted to microsoft.public.excel.programming

Forrest[_3_] Forrest[_3_] is offline

external usenet poster

Posts: 11

VBA Function syntax

I currently have an Access module that drops data into Excel and places the cursor below the last row of the last column. I want to programically place Excel's IRR function in this cell. Column A contains the dates and column C the amount field. Code snippet

' Selects c7; first blank cell at the bottom of a contiguous colum
xlWs.Range("c1").End(xlDown).Offset(1, 0).Selec

Thanks

Forrest

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
Indirect function syntax	Matt	Excel Discussion (Misc queries)	4	October 9th 08 10:43 PM
Syntax for IF function	Sarah	New Users to Excel	1	July 31st 06 01:57 PM
Syntax for 2 AND conditions within an OR function.	Mike K	Excel Worksheet Functions	5	June 3rd 05 12:06 AM
all function formulas syntax	azeem mansoori	Excel Discussion (Misc queries)	1	May 28th 05 11:56 AM
NetWorkDays Function Syntax	Lamar	Excel Worksheet Functions	2	April 12th 05 10:02 AM

All times are GMT +1. The time now is 05:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us