LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default calling a macro within an excel formula

Is it possible to call a macro from within and excel 2003 If statement as
follows:

=If(IF(M2 <=LASTSN,copymacro[then i want to call a print macro and move down
a row and repeat this formula for M3, until M# is no longer <= LASTSN)

I have been unsuccessfully trying to find and modify macros that others used
to create sequential serial numbers for a week now, and have not yet got them
to work; probably because I have never worked with Visual Basic before and do
not really understand its syntax.

--
rahne059
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Calling a macro in excel Rodney Crow Excel Programming 1 February 5th 08 02:42 AM
calling macro in a formula rk0909 Excel Discussion (Misc queries) 2 March 14th 06 04:15 PM
calling excel macro TommyBoy Excel Programming 0 August 12th 04 10:25 PM
Calling Excel Macro From Vc++ via DDE hari Excel Programming 0 July 6th 04 12:50 PM
calling a dll from excel macro Stefan[_4_] Excel Programming 1 December 12th 03 12:16 AM


All times are GMT +1. The time now is 04:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"