 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / May 2008nest macro in a formula
i am comparing pairs of cells in a column of data using an if statement. if the statement is false i would like to add a row between them. i have created a macro that just adds a row but i dont know how to nest it in an if statement nor do i know exactly how to make sure that excel knows that i want to add the new row above. i have tried to copy and past in vb but i am very new to this and hope someone can help. using excel 2003  SignatureBBoyd You can't call/run a macro from a worksheet formula. What you will need to do is have another macro which contains your IF THEN ELSE ENDIF statement and for this to call your first macro to insert the row. Hope this helps. Pete > i am comparing pairs of cells in a column of data using an if statement. if > the statement is false i would like to add a row between them. i have [quoted text clipped - 4 lines] > -- > BBoyd not exactly sure what yoy mean. i will try to attach an example soon. thank you for your time. SignatureBBoyd > You can't call/run a macro from a worksheet formula. What you will > need to do is have another macro which contains your IF THEN ELSE [quoted text clipped - 13 lines] > > -- > > BBoyd |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.