You are here:

Excel/simplifying a macro

Advertisement


Question
Hi Tom

I have recorded two very clumsy macros with the macro recorder.  I need to know if there is any way of making them faster with alternative code.

Could you have a look at them and make any suggestions?

Chris Mitchell

MACRO 1:

Sheets("Sheet2rng").Select
   Range("CB2:CB360").Select
   Selection.Copy
   ActiveWindow.ScrollRow = 340
   ActiveWindow.ScrollRow = 333
   ActiveWindow.ScrollRow = 318
   ActiveWindow.ScrollRow = 302
   ActiveWindow.ScrollRow = 274
   ActiveWindow.ScrollRow = 245
   ActiveWindow.ScrollRow = 213
   ActiveWindow.ScrollRow = 183
   ActiveWindow.ScrollRow = 148
   ActiveWindow.ScrollRow = 115
   ActiveWindow.ScrollRow = 91
   ActiveWindow.ScrollRow = 74
   ActiveWindow.ScrollRow = 57
   ActiveWindow.ScrollRow = 42
   ActiveWindow.ScrollRow = 28
   ActiveWindow.ScrollRow = 15
   ActiveWindow.ScrollRow = 8
   ActiveWindow.ScrollRow = 1
   Range("W2").Select
   ActiveSheet.Paste
   Application.CutCopyMode = False
   ActiveWindow.ScrollRow = 4
   ActiveWindow.ScrollRow = 8
   ActiveWindow.ScrollRow = 10
   ActiveWindow.ScrollRow = 13
   ActiveWindow.ScrollRow = 17
   ActiveWindow.ScrollRow = 20
   ActiveWindow.ScrollRow = 23
   ActiveWindow.ScrollRow = 25
   ActiveWindow.ScrollRow = 28
   ActiveWindow.ScrollRow = 34
   ActiveWindow.ScrollRow = 36
   ActiveWindow.ScrollRow = 39
   ActiveWindow.ScrollRow = 40
   ActiveWindow.ScrollRow = 42
   ActiveWindow.ScrollRow = 44
   ActiveWindow.ScrollRow = 46
   ActiveWindow.ScrollRow = 47
   ActiveWindow.ScrollRow = 50
   ActiveWindow.ScrollRow = 51
   ActiveWindow.ScrollRow = 54
   ActiveWindow.ScrollRow = 57
   ActiveWindow.ScrollRow = 58
   ActiveWindow.ScrollRow = 61
   ActiveWindow.ScrollRow = 63
   ActiveWindow.ScrollRow = 65
   ActiveWindow.ScrollRow = 66
   ActiveWindow.ScrollRow = 67
   ActiveWindow.ScrollRow = 69
   ActiveWindow.ScrollRow = 72
   ActiveWindow.ScrollRow = 74
   ActiveWindow.ScrollRow = 76
   ActiveWindow.ScrollRow = 78
   ActiveWindow.ScrollRow = 81
   ActiveWindow.ScrollRow = 84
   ActiveWindow.ScrollRow = 85
   ActiveWindow.ScrollRow = 86
   ActiveWindow.ScrollRow = 89
   ActiveWindow.ScrollRow = 91
   ActiveWindow.ScrollRow = 92
   ActiveWindow.ScrollRow = 93
   ActiveWindow.ScrollRow = 95
   ActiveWindow.ScrollRow = 96
   ActiveWindow.ScrollRow = 97
   ActiveWindow.ScrollRow = 99
   ActiveWindow.ScrollRow = 100
   ActiveWindow.ScrollRow = 103
   ActiveWindow.ScrollRow = 105
   ActiveWindow.ScrollRow = 107
   ActiveWindow.ScrollRow = 110
   ActiveWindow.ScrollRow = 112
   ActiveWindow.ScrollRow = 115
   ActiveWindow.ScrollRow = 116
   ActiveWindow.ScrollRow = 119
   ActiveWindow.ScrollRow = 123
   ActiveWindow.ScrollRow = 126
   ActiveWindow.ScrollRow = 127
   ActiveWindow.ScrollRow = 129
   ActiveWindow.ScrollRow = 130
   ActiveWindow.ScrollRow = 131
   ActiveWindow.ScrollRow = 135
   ActiveWindow.ScrollRow = 143
   ActiveWindow.ScrollRow = 161
   ActiveWindow.ScrollRow = 167
   ActiveWindow.ScrollRow = 169
   ActiveWindow.ScrollRow = 173
   ActiveWindow.ScrollRow = 177
   ActiveWindow.ScrollRow = 179
   ActiveWindow.ScrollRow = 183
   ActiveWindow.ScrollRow = 188
   ActiveWindow.ScrollRow = 190
   ActiveWindow.ScrollRow = 194
   ActiveWindow.ScrollRow = 198
   ActiveWindow.ScrollRow = 203
   ActiveWindow.ScrollRow = 206
   ActiveWindow.ScrollRow = 211
   ActiveWindow.ScrollRow = 219
   ActiveWindow.ScrollRow = 225
   ActiveWindow.ScrollRow = 228
   ActiveWindow.ScrollRow = 230
   ActiveWindow.ScrollRow = 232
   ActiveWindow.ScrollRow = 236
   ActiveWindow.ScrollRow = 238
   ActiveWindow.ScrollRow = 241
   ActiveWindow.ScrollRow = 243
   ActiveWindow.ScrollRow = 244
   ActiveWindow.ScrollRow = 247
   ActiveWindow.ScrollRow = 248
   ActiveWindow.ScrollRow = 249
   ActiveWindow.ScrollRow = 252
   ActiveWindow.ScrollRow = 256
   ActiveWindow.ScrollRow = 259
   ActiveWindow.ScrollRow = 262
   ActiveWindow.ScrollRow = 267
   ActiveWindow.ScrollRow = 274
   ActiveWindow.ScrollRow = 278
   ActiveWindow.ScrollRow = 285
   ActiveWindow.ScrollRow = 287
   ActiveWindow.ScrollRow = 291
   ActiveWindow.ScrollRow = 301
   ActiveWindow.ScrollRow = 305
   ActiveWindow.ScrollRow = 309
   ActiveWindow.ScrollRow = 313
   ActiveWindow.ScrollRow = 316
   ActiveWindow.ScrollRow = 318
   ActiveWindow.ScrollRow = 320
   ActiveWindow.ScrollRow = 321
   ActiveWindow.ScrollRow = 323
   ActiveWindow.ScrollRow = 324
   ActiveWindow.ScrollRow = 327
   ActiveWindow.ScrollRow = 328
   ActiveWindow.ScrollRow = 329
   ActiveWindow.ScrollRow = 332
   ActiveWindow.ScrollRow = 333
   ActiveWindow.ScrollRow = 335
   ActiveWindow.ScrollRow = 337
   ActiveWindow.ScrollRow = 339
   ActiveWindow.ScrollRow = 340
   ActiveWindow.ScrollRow = 342
   ActiveWindow.ScrollRow = 344
   ActiveWindow.ScrollRow = 346
   ActiveWindow.ScrollRow = 348
   ActiveWindow.ScrollRow = 351
   ActiveWindow.ScrollRow = 355
   ActiveWindow.ScrollRow = 356
   ActiveWindow.ScrollRow = 359
   ActiveWindow.ScrollRow = 361
   ActiveWindow.ScrollRow = 362
   ActiveWindow.ScrollRow = 363
   ActiveWindow.ScrollRow = 365
   ActiveWindow.ScrollRow = 363
   ActiveWindow.ScrollRow = 362
   ActiveWindow.ScrollRow = 359
   ActiveWindow.ScrollRow = 358
   ActiveWindow.ScrollRow = 356
   ActiveWindow.ScrollRow = 355
   ActiveWindow.ScrollRow = 354
   Range("CC361:CC708").Select
   Selection.Copy
   ActiveWindow.ScrollRow = 696
   ActiveWindow.ScrollRow = 693
   ActiveWindow.ScrollRow = 686
   ActiveWindow.ScrollRow = 683
   ActiveWindow.ScrollRow = 677
   ActiveWindow.ScrollRow = 673
   ActiveWindow.ScrollRow = 666
   ActiveWindow.ScrollRow = 663
   ActiveWindow.ScrollRow = 656
   ActiveWindow.ScrollRow = 651
   ActiveWindow.ScrollRow = 647
   ActiveWindow.ScrollRow = 643
   ActiveWindow.ScrollRow = 636
   ActiveWindow.ScrollRow = 631
   ActiveWindow.ScrollRow = 626
   ActiveWindow.ScrollRow = 618
   ActiveWindow.ScrollRow = 609
   ActiveWindow.ScrollRow = 601
   ActiveWindow.ScrollRow = 589
   ActiveWindow.ScrollRow = 572
   ActiveWindow.ScrollRow = 559
   ActiveWindow.ScrollRow = 549
   ActiveWindow.ScrollRow = 544
   ActiveWindow.ScrollRow = 541
   ActiveWindow.ScrollRow = 538
   ActiveWindow.ScrollRow = 537
   ActiveWindow.ScrollRow = 534
   ActiveWindow.ScrollRow = 533
   ActiveWindow.ScrollRow = 530
   ActiveWindow.ScrollRow = 526
   ActiveWindow.ScrollRow = 523
   ActiveWindow.ScrollRow = 517
   ActiveWindow.ScrollRow = 514
   ActiveWindow.ScrollRow = 507
   ActiveWindow.ScrollRow = 504
   ActiveWindow.ScrollRow = 500
   ActiveWindow.ScrollRow = 492
   ActiveWindow.ScrollRow = 488
   ActiveWindow.ScrollRow = 480
   ActiveWindow.ScrollRow = 477
   ActiveWindow.ScrollRow = 472
   ActiveWindow.ScrollRow = 464
   ActiveWindow.ScrollRow = 456
   ActiveWindow.ScrollRow = 453
   ActiveWindow.ScrollRow = 450
   ActiveWindow.ScrollRow = 443
   ActiveWindow.ScrollRow = 442
   ActiveWindow.ScrollRow = 441
   ActiveWindow.ScrollRow = 438
   ActiveWindow.ScrollRow = 435
   ActiveWindow.ScrollRow = 432
   ActiveWindow.ScrollRow = 431
   ActiveWindow.ScrollRow = 430
   ActiveWindow.ScrollRow = 428
   ActiveWindow.ScrollRow = 424
   ActiveWindow.ScrollRow = 423
   ActiveWindow.ScrollRow = 420
   ActiveWindow.ScrollRow = 419
   ActiveWindow.ScrollRow = 418
   ActiveWindow.ScrollRow = 415
   ActiveWindow.ScrollRow = 412
   ActiveWindow.ScrollRow = 411
   ActiveWindow.ScrollRow = 408
   ActiveWindow.ScrollRow = 405
   ActiveWindow.ScrollRow = 403
   ActiveWindow.ScrollRow = 400
   ActiveWindow.ScrollRow = 399
   ActiveWindow.ScrollRow = 397
   ActiveWindow.ScrollRow = 394
   ActiveWindow.ScrollRow = 392
   ActiveWindow.ScrollRow = 390
   ActiveWindow.ScrollRow = 386
   ActiveWindow.ScrollRow = 385
   ActiveWindow.ScrollRow = 384
   ActiveWindow.ScrollRow = 382
   ActiveWindow.ScrollRow = 381
   ActiveWindow.ScrollRow = 380
   ActiveWindow.ScrollRow = 378
   ActiveWindow.ScrollRow = 377
   ActiveWindow.ScrollRow = 375
   ActiveWindow.ScrollRow = 374
   ActiveWindow.ScrollRow = 373
   ActiveWindow.ScrollRow = 370
   ActiveWindow.ScrollRow = 367
   ActiveWindow.ScrollRow = 366
   ActiveWindow.ScrollRow = 365
   ActiveWindow.ScrollRow = 363
   ActiveWindow.ScrollRow = 359
   ActiveWindow.ScrollRow = 356
   ActiveWindow.ScrollRow = 354
   ActiveWindow.ScrollRow = 352
   ActiveWindow.ScrollRow = 350
   ActiveWindow.ScrollRow = 347
   ActiveWindow.ScrollRow = 346
   ActiveWindow.ScrollRow = 344
   ActiveWindow.ScrollRow = 343
   ActiveWindow.ScrollRow = 342
   ActiveWindow.ScrollRow = 340
   ActiveWindow.ScrollRow = 337
   ActiveWindow.ScrollRow = 336
   ActiveWindow.ScrollRow = 335
   ActiveWindow.ScrollRow = 333
   ActiveWindow.ScrollRow = 332
   ActiveWindow.ScrollRow = 331
   ActiveWindow.ScrollRow = 328
   ActiveWindow.ScrollRow = 325
   ActiveWindow.ScrollRow = 323
   ActiveWindow.ScrollRow = 320
   ActiveWindow.ScrollRow = 318
   ActiveWindow.ScrollRow = 317
   ActiveWindow.ScrollRow = 316
   ActiveWindow.ScrollRow = 314
   ActiveWindow.ScrollRow = 316
   ActiveWindow.ScrollRow = 320
   ActiveWindow.ScrollRow = 335
   ActiveWindow.ScrollRow = 347
   ActiveWindow.ScrollRow = 351
   ActiveWindow.ScrollRow = 352
   ActiveWindow.ScrollRow = 354
   ActiveWindow.ScrollRow = 355
   ActiveWindow.ScrollRow = 356
   ActiveWindow.ScrollRow = 358
   Range("W361").Select
   ActiveSheet.Paste
   Application.CutCopyMode = False
   ActiveWindow.ScrollRow = 359
   ActiveWindow.ScrollRow = 361
   ActiveWindow.ScrollRow = 365
   ActiveWindow.ScrollRow = 369
   ActiveWindow.ScrollRow = 371
   ActiveWindow.ScrollRow = 375
   ActiveWindow.ScrollRow = 381
   ActiveWindow.ScrollRow = 385
   ActiveWindow.ScrollRow = 390
   ActiveWindow.ScrollRow = 396
   ActiveWindow.ScrollRow = 401
   ActiveWindow.ScrollRow = 404
   ActiveWindow.ScrollRow = 405
   ActiveWindow.ScrollRow = 407
   ActiveWindow.ScrollRow = 409
   ActiveWindow.ScrollRow = 415
   ActiveWindow.ScrollRow = 418
   ActiveWindow.ScrollRow = 420
   ActiveWindow.ScrollRow = 422
   ActiveWindow.ScrollRow = 423
   ActiveWindow.ScrollRow = 424
   ActiveWindow.ScrollRow = 428
   ActiveWindow.ScrollRow = 431
   ActiveWindow.ScrollRow = 434
   ActiveWindow.ScrollRow = 437
   ActiveWindow.ScrollRow = 439
   ActiveWindow.ScrollRow = 446
   ActiveWindow.ScrollRow = 449
   ActiveWindow.ScrollRow = 454
   ActiveWindow.ScrollRow = 461
   ActiveWindow.ScrollRow = 465
   ActiveWindow.ScrollRow = 468
   ActiveWindow.ScrollRow = 475
   ActiveWindow.ScrollRow = 479
   ActiveWindow.ScrollRow = 487
   ActiveWindow.ScrollRow = 489
   ActiveWindow.ScrollRow = 494
   ActiveWindow.ScrollRow = 499
   ActiveWindow.ScrollRow = 503
   ActiveWindow.ScrollRow = 507
   ActiveWindow.ScrollRow = 515
   ActiveWindow.ScrollRow = 523
   ActiveWindow.ScrollRow = 526
   ActiveWindow.ScrollRow = 530
   ActiveWindow.ScrollRow = 536
   ActiveWindow.ScrollRow = 538
   ActiveWindow.ScrollRow = 540
   ActiveWindow.ScrollRow = 541
   ActiveWindow.ScrollRow = 545
   ActiveWindow.ScrollRow = 546
   ActiveWindow.ScrollRow = 549
   ActiveWindow.ScrollRow = 551
   ActiveWindow.ScrollRow = 552
   ActiveWindow.ScrollRow = 553
   ActiveWindow.ScrollRow = 555
   ActiveWindow.ScrollRow = 556
   ActiveWindow.ScrollRow = 560
   ActiveWindow.ScrollRow = 561
   ActiveWindow.ScrollRow = 565
   ActiveWindow.ScrollRow = 574
   ActiveWindow.ScrollRow = 576
   ActiveWindow.ScrollRow = 584
   ActiveWindow.ScrollRow = 589
   ActiveWindow.ScrollRow = 591
   ActiveWindow.ScrollRow = 599
   ActiveWindow.ScrollRow = 606
   ActiveWindow.ScrollRow = 607
   ActiveWindow.ScrollRow = 610
   ActiveWindow.ScrollRow = 612
   ActiveWindow.ScrollRow = 613
   ActiveWindow.ScrollRow = 614
   ActiveWindow.ScrollRow = 616
   ActiveWindow.ScrollRow = 617
   ActiveWindow.ScrollRow = 624
   ActiveWindow.ScrollRow = 633
   ActiveWindow.ScrollRow = 636
   ActiveWindow.ScrollRow = 639
   ActiveWindow.ScrollRow = 641
   ActiveWindow.ScrollRow = 643
   ActiveWindow.ScrollRow = 644
   ActiveWindow.ScrollRow = 647
   ActiveWindow.ScrollRow = 652
   ActiveWindow.ScrollRow = 655
   ActiveWindow.ScrollRow = 659
   ActiveWindow.ScrollRow = 664
   ActiveWindow.ScrollRow = 667
   ActiveWindow.ScrollRow = 669
   ActiveWindow.ScrollRow = 671
   ActiveWindow.ScrollRow = 673
   ActiveWindow.ScrollRow = 674
   ActiveWindow.ScrollRow = 677
   ActiveWindow.ScrollRow = 678
   ActiveWindow.ScrollRow = 679
   ActiveWindow.ScrollRow = 681
   ActiveWindow.ScrollRow = 683
   ActiveWindow.ScrollRow = 685
   ActiveWindow.ScrollRow = 686
   ActiveWindow.ScrollRow = 689
   ActiveWindow.ScrollRow = 693
   ActiveWindow.ScrollRow = 694
   ActiveWindow.ScrollRow = 696
   ActiveWindow.ScrollRow = 697
   ActiveWindow.ScrollRow = 698
   ActiveWindow.ScrollRow = 701
   ActiveWindow.ScrollRow = 702
   ActiveWindow.ScrollRow = 704
   ActiveWindow.ScrollRow = 705
   ActiveWindow.ScrollRow = 704
   ActiveWindow.ScrollRow = 702
   ActiveWindow.ScrollRow = 701
   ActiveWindow.ScrollRow = 700
   Range("CD709:CD905").Select
   Selection.Copy
   ActiveWindow.ScrollRow = 884
   ActiveWindow.ScrollRow = 883
   ActiveWindow.ScrollRow = 873
   ActiveWindow.ScrollRow = 867
   ActiveWindow.ScrollRow = 859
   ActiveWindow.ScrollRow = 849
   ActiveWindow.ScrollRow = 845
   ActiveWindow.ScrollRow = 834
   ActiveWindow.ScrollRow = 829
   ActiveWindow.ScrollRow = 815
   ActiveWindow.ScrollRow = 800
   ActiveWindow.ScrollRow = 784
   ActiveWindow.ScrollRow = 770
   ActiveWindow.ScrollRow = 766
   ActiveWindow.ScrollRow = 755
   ActiveWindow.ScrollRow = 746
   ActiveWindow.ScrollRow = 742
   ActiveWindow.ScrollRow = 734
   ActiveWindow.ScrollRow = 731
   ActiveWindow.ScrollRow = 723
   ActiveWindow.ScrollRow = 716
   ActiveWindow.ScrollRow = 707
   ActiveWindow.ScrollRow = 700
   ActiveWindow.ScrollRow = 686
   ActiveWindow.ScrollRow = 674
   ActiveWindow.ScrollRow = 659
   ActiveWindow.ScrollRow = 655
   ActiveWindow.ScrollRow = 651
   ActiveWindow.ScrollRow = 644
   ActiveWindow.ScrollRow = 640
   ActiveWindow.ScrollRow = 635
   ActiveWindow.ScrollRow = 631
   ActiveWindow.ScrollRow = 626
   ActiveWindow.ScrollRow = 620
   ActiveWindow.ScrollRow = 616
   ActiveWindow.ScrollRow = 613
   ActiveWindow.ScrollRow = 607
   ActiveWindow.ScrollRow = 601
   ActiveWindow.ScrollRow = 597
   ActiveWindow.ScrollRow = 591
   ActiveWindow.ScrollRow = 589
   ActiveWindow.ScrollRow = 587
   ActiveWindow.ScrollRow = 586
   ActiveWindow.ScrollRow = 584
   ActiveWindow.ScrollRow = 583
   ActiveWindow.ScrollRow = 580
   ActiveWindow.ScrollRow = 582
   ActiveWindow.ScrollRow = 587
   ActiveWindow.ScrollRow = 595
   ActiveWindow.ScrollRow = 612
   ActiveWindow.ScrollRow = 628
   ActiveWindow.ScrollRow = 635
   ActiveWindow.ScrollRow = 641
   ActiveWindow.ScrollRow = 644
   ActiveWindow.ScrollRow = 648
   ActiveWindow.ScrollRow = 651
   ActiveWindow.ScrollRow = 654
   ActiveWindow.ScrollRow = 656
   ActiveWindow.ScrollRow = 659
   ActiveWindow.ScrollRow = 660
   ActiveWindow.ScrollRow = 662
   ActiveWindow.ScrollRow = 669
   ActiveWindow.ScrollRow = 671
   ActiveWindow.ScrollRow = 673
   ActiveWindow.ScrollRow = 675
   ActiveWindow.ScrollRow = 678
   ActiveWindow.ScrollRow = 681
   ActiveWindow.ScrollRow = 682
   ActiveWindow.ScrollRow = 685
   ActiveWindow.ScrollRow = 688
   ActiveWindow.ScrollRow = 689
   Range("W709").Select
   ActiveSheet.Paste
   Application.CutCopyMode = False
   Sheets("Main").Select
   Range("A1").Select
   Calculate
End Sub



MACRO 2:

Sub SCHSTANTARGETS()
'
' SCHSTANTARGETS Macro
'

'
   Range("A1").Select
   Sheets("Sheet2rng").Select
   Range("CF2:CF1238").Select
   Selection.Copy
   ActiveWindow.ScrollRow = 1195
   ActiveWindow.ScrollRow = 1189
   ActiveWindow.ScrollRow = 1182
   ActiveWindow.ScrollRow = 1158
   ActiveWindow.ScrollRow = 1131
   ActiveWindow.ScrollRow = 1093
   ActiveWindow.ScrollRow = 1040
   ActiveWindow.ScrollRow = 957
   ActiveWindow.ScrollRow = 892
   ActiveWindow.ScrollRow = 824
   ActiveWindow.ScrollRow = 702
   ActiveWindow.ScrollRow = 562
   ActiveWindow.ScrollRow = 460
   ActiveWindow.ScrollRow = 385
   ActiveWindow.ScrollRow = 281
   ActiveWindow.ScrollRow = 236
   ActiveWindow.ScrollRow = 183
   ActiveWindow.ScrollRow = 130
   ActiveWindow.ScrollRow = 81
   ActiveWindow.ScrollRow = 31
   ActiveWindow.ScrollRow = 1
   Range("W2").Select
   ActiveSheet.Paste
   Application.CutCopyMode = False
   Sheets("Main").Select
   Range("A1").Select
   Calculate
End Sub

Answer
Christopher Mitchell.

You have the command calculate in each of your macros.  But that would indicate you have formulas in the sheet and that can slow down copy and paste operations so I just set calculation to manual, did the code, and then at the end back to automatic (I am assuming you have it set to automatic by default).

Other than that, there wasn't a lot going on in the macros.  This is what I came up with:

I think turning calculation back to automatic will execute a calculate but if that doesn't appear to be the case, just type in

calculate

at the end of each macro.  

Sub Macro1()
Application.Calculation = xlManual
With Sheets("Sheet2rng")
.Range("CB2:CB360").Copy .Range("W2")
Application.CutCopyMode = False
.Range("CC361:CC708").Copy .Range("W361")
Application.CutCopyMode = False
.Range("CD709:CD905").Copy .Range("W709")
Application.CutCopyMode = False
End With
Application.Calculation = xlAutomatic
Sheets("Main").Select
Range("A1").Select
End Sub



Sub SCHSTANTARGETS()
'
' SCHSTANTARGETS Macro
'

Application.Calculation = xlManual
With Sheets("Sheet2rng")
 .Range("CF2:CF1238").Copy .Range("W2")
Application.CutCopyMode = False
End With
Sheets("Main").Select
Range("A1").Select
Application.Calculation = xlAutomatic
End Sub

Hope that helps.

--
Regards,
Tom Ogilvy

About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

Excel

All Answers


Answers by Expert:


Ask Experts

Volunteer


Tom Ogilvy

Expertise

Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want. [Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]

Experience

Extensive experience.

Education/Credentials
Master of Science (MS) degree Operations Research (ORSA)

Awards and Honors
Microsoft MVP in Excel.

©2016 About.com. All rights reserved.