Transcription of Excel 4.0 Macro Functions Reference
1 Excel Macro Functions Reference A COMPREHENSIVE LIST OF microsoft Excel Macro Functions . Philip Treacy CO-FOUNDER MY ONLINE TRAINING HUB. 1. CONTENTS. Introduction .. 22.. 23. ABSREF .. 23. ACTIVATE .. 24. , .. 25.. 26.. 27.. 27.. 28.. 28.. 29.. 33.. 34.. 34.. 36.. 36.. 39. ALERT .. 40. ALIGNMENT .. 42. ANOVA1 .. 44. ANOVA2 .. 45. ANOVA3 .. 46.. 46.. 48.. 48.. 50.. 50.. 50. 51.. 52.. 52.. 53. ARGUMENT .. 53. 2.. 55.. 57. 57.. 58.. 59.. 59. AXES .. 60. BEEP .. 60. BORDER .. 61. BREAK .. 62.. 62.. 63.. 63. CALCULATION .. 63. CALLER .. 65.. 67.. 67.. 68.. 69.. 69.. 70.. 72.. 74.. 75. CLEAR .. 76.. 78. 78. CLOSE .. 78.. 79.. 80.. 80. COMBINATION .. 81. CONSOLIDATE.
2 82.. 84. 3. COPY .. 84.. 85.. 85.. 87.. 87.. 88.. 92.. 94.. 95.. 96. CUT .. 97.. 97. 98. , .. 98.. 98.. 99.. 99.. 101.. 103. Syntax 1 .. 103. Syntaxes 2 - 7 .. 104.. 106. 106.. 106.. 107.. 108.. 108.. 109. 109.. 109.. 110.. 110. DEMOTE .. 111. DEREF .. 111. 4. DESCR .. 112.. 113. DIRECTORY .. 116.. 117. 117. DISPLAY Syntax 1 .. 117. DISPLAY Syntax 2 .. 118. DOCUMENTS .. 120. DUPLICATE .. 121. ECHO .. 121.. 122.. 122.. 123.. 124.. 127.. 128.. 128.. 129. ELSE .. 130.. 130. EMBED .. 131.. 131.. 132.. 133.. 133.. 133.. 134. ERROR .. 135. , .. 136. EVALUATE .. 139. EXEC .. 139. EXECUTE .. 141. 142.. 143. 5. EXTRACT .. 143. FCLOSE .. 144.. 144.. 145. FILES .. 146.
3 148. , , , .. 149. 149. FILTER .. 150.. 151.. 151.. 151. FONT .. 152.. 152. FOPEN .. 154. FOR .. 155.. 156.. 157. 159.. 161.. 162.. 164.. 165.. 167. Syntax 1 .. 168. Syntax 2 .. 169. Syntax 3 .. 169.. 170.. 170.. 172.. 174. Syntax 1 .. 174. Syntax 2 .. 174.. 175. 6. FORMULA .. 177. FORMULA Syntax 1 .. 177. FORMULA Syntax 2 .. 179.. 180.. 181. 182.. 182. , .. 184. 184.. 185. FOURIER .. 187. FPOS .. 187. FREAD .. 188. FREADLN .. 189. 189. FSIZE .. 190. FTESTV .. 191. FULL .. 191.. 191.. 192. FWRITE .. 192. FWRITELN .. 192.. 193.. 193.. 194.. 194.. 194.. 194. 194.. 195.. 195.. 196.. 196.. 196. 7.. 197.. 197.. 198.. 198. Syntax 1 .. 198. Syntax 2 .. 199.. 200.. 206.
4 209. 210.. 220.. 221.. 222.. 223. 224.. 233.. 235.. 237.. 239.. 241.. 243.. 246. 250.. 257. GOTO .. 258. GRIDLINES .. 259. GROUP .. 259. ECHO .. 260.. 260.. 261.. 262.. 263.. 266.. 266. 8.. 266.. 268. ELSE .. 268.. 268. EMBED .. 269.. 270.. 271.. 271.. 271.. 272.. 272. ERROR .. 273. , .. 275. EVALUATE .. 277. EXEC .. 278. EXECUTE .. 279. 281.. 281. EXTRACT .. 282. FCLOSE .. 282.. 283.. 284. FILES .. 285.. 286. , , , .. 287. 288. FILTER .. 288.. 289.. 290.. 290. FONT .. 290.. 290. FOPEN .. 292. FOR .. 294. 9.. 295.. 296. 298.. 300.. 301.. 303.. 304.. 306. Syntax 1 .. 307. Syntax 2 .. 308. Syntax 3 .. 308.. 309.. 309.. 311.. 313. Syntax 1 .. 313. Syntax 2 .. 313.
5 314. FORMULA .. 316. FORMULA Syntax 1 .. 316. FORMULA Syntax 2 .. 318.. 319.. 320. 321.. 321. , .. 323. 323.. 324. FOURIER .. 326. FPOS .. 326. FREAD .. 327. FREADLN .. 328. 328. FSIZE .. 329. 10. FTESTV .. 329. FULL .. 330.. 330.. 330. FWRITE .. 331. FWRITELN .. 331.. 332.. 332.. 332.. 333.. 333.. 333. 333.. 334.. 334.. 334.. 335.. 335.. 336.. 336.. 336.. 337. Syntax 1 .. 337. Syntax 2 .. 337.. 339.. 345.. 348. 349.. 359.. 360.. 361.. 362. 363.. 372. 11.. 374.. 376.. 378.. 380.. 382.. 385. 389.. 396. GOTO .. 397. GRIDLINES .. 398. GROUP .. 398. 399. HELP .. 399. HIDE .. 401.. 401.. 401. HISTOGRAM .. 402. HLINE .. 403. HPAGE .. 404. HSCROLL .. 404. IF .. 405.
6 Tips .. 405. INITIATE .. 406. INPUT .. 407. INSERT .. 409.. 410.. 411.. 412. JUSTIFY .. 413.. 413.. 414. 414.. 415.. 417. 12.. 418. LINKS .. 418.. 419.. 420.. 421.. 421.. 422.. 422.. 423. 423.. 423.. 424.. 424.. 425.. 425.. 425.. 426. MCORREL .. 426. MCOVAR .. 427.. 428.. 428. MESSAGE .. 428. MOVE .. 429. MOVEAVG .. 430. 430. NAMES .. 431. NEW .. 432.. 434. NEXT .. 434. NOTE .. 434.. 435.. 436.. 436.. 438. 13.. 438.. 439.. 442.. 443.. 443.. 444. OPEN .. 445. 448.. 449.. 450.. 451.. 452.. 453.. 454. 455.. 456.. 457.. 457.. 458.. 459. OUTLINE .. 460. OVERLAY .. 461.. 461. PARSE .. 467. PASTE .. 468.. 468.. 469.. 469.. 469. Syntax 1 .. 470. Syntax 2 .. 471. Syntax 3.
7 472. Syntax 4 .. 473.. 474. 14. PATTERNS .. 475. PAUSE .. 482.. 483.. 485.. 486.. 487.. 489.. 492.. 493.. 494.. 495.. 495.. 496. PLACEMENT .. 498. POKE .. 498. PRECISION .. 499. PREFERRED .. 500.. 500. PRINT .. 500.. 503.. 503. 503.. 504. PTTESTM .. 505. PTTESTV .. 506.. 507.. 507.. 508. QUIT .. 509. RANDOM .. 509. RANKPERC .. 511. REFTEXT .. 512. REGISTER .. 513. REGRESS .. 515. 15. RELREF .. 517.. 517.. 518.. 518.. 519.. 519.. 520.. 520.. 521.. 522. REQUEST .. 522.. 523. 524. RESTART .. 524. RESULT .. 525. RESUME .. 526. 526.. 527.. 527.. 529. 530. SAMPLE .. 531. SAVE .. 532.. 532.. 535.. 536.. 537.. 537. 538. 538. SCALE Syntax 1 .. 538. SCALE Syntax 2 .. 539.
8 SCALE Syntax 3 .. 540. SCALE Syntax 4 .. 541. 16. SCALE Syntax 5 .. 541.. 542.. 543.. 544.. 544.. 545. 546.. 546.. 546. 547.. 547. SELECT .. 548. SELECT Syntax 548. SELECT Syntax 550. SELECT Syntax 551.. 553.. 554.. 554. SELECTION .. 555.. 556.. 557.. 557.. 557.. 559.. 560.. 561. SERIES .. 561.. 562.. 562.. 562.. 563.. 563.. 564.. 564. 17.. 564.. 565. 565.. 565.. 566.. 567.. 568. 568.. 569.. 570.. 571.. 572.. 572.. 572.. 574.. 574. 575.. 575.. 575.. 576. SIZE .. 578.. 578.. 579.. 579.. 579.. 580.. 580.. 581.. 583.. 583.. 584.. 586.. 586. 586. 18.. 587.. 589.. 589.. 590.. 591.. 591.. 592. SORT .. 593.. 595.. 596. 597.. 598. SPLIT .. 598.. 598.. 600.. 600. 602.
9 603.. 605.. 607.. 609.. 611.. 611. STEP .. 611. STYLE .. 612.. 612.. 613.. 614. 615. TABLE .. 615.. 616. TERMINATE .. 616.. 617. TEXTREF .. 617. 19. 618.. 620.. 620.. 620.. 621. TTESTM .. 622. 622. UNGROUP .. 622. UNHIDE .. 623. , .. 623. UNREGISTER .. 623.. 625.. 625.. 626.. 626.. 627.. 628.. 628.. 629. 630. VOLATILE .. 630. VPAGE .. 631. VSCROLL .. 631. WAIT .. 632. WHILE .. 633.. 633.. 634.. 634.. 635. WINDOWS .. 636.. 637.. 638.. 639.. 639. 20.. 640.. 640.. 641.. 641.. 642.. 643.. 643.. 644.. 644.. 644.. 645.. 645.. 645.. 646.. 646. WORKGROUP .. 647. WORKSPACE .. 647. ZOOM .. 649. ZTESTM .. 649. More resources .. 651. About .. 653. Thanks .. 653. 21. INTRODUCTION.
10 Before Visual Basic for Applications, there were Excel macros, or XLM. VBA was introduced in Excel version so these older XLM macros are also known as Excel 4 Macros. To use an Excel Macro does not require any programming. You use them like a function = (64,A1). This gives you the ColorIndex of the background of cell A1. However you can't just stick them into your worksheet. If you combine them with defined names they can be very useful and can do things that would normally require a VBA solution. The definitions for the Macro Functions in this book are taken from the official microsoft Excel Macros help file. When I was looking for a Reference for these macros I could not easily find one as the old help files are no longer supported in Windows 10.
