Agregador de canales de noticias

Deleting Worksheets in a Macro

Allen Wyatt's Excel tips -

Processing workbooks using a macro often involves the possible creation and subsequent deletion of worksheets. When it comes to deleting worksheets in a macro, the way that Excel processes the Delete method can hinder the quick automation often desired when doing the processing. Here's how to speed up worksheet deletion so that your automation can run at top speed.

Read this ExcelTip: Deleting Worksheets in a Macro
Microsoft Excel Tips - Learn Excel Faster!

Power Query Challenge #2 Results

Excel guru -

What an overwhelming response to Power Query Challenge #2!  We had 40 submissions, and some with multiple entries in a single submission.  Plainly you all enjoyed this! Naturally, there were a couple...

continue reading...


Subscribe to agregador