Tag: vba

44 Copy Excel worksheet and maintain relative cell reference in formulas 2012-03-06T08:47:35.830

40 How to bypass the VBA project password from Excel 2014-09-05T21:48:49.383

34 How can I use custom colours in the Microsoft VBA editor? 2011-07-21T19:04:42.560

31 Limit Excel CPU Usage 2016-01-12T20:26:48.310

29 Can I make an Excel VBA macro available to all workbooks? 2011-09-25T17:57:12.837

27 Open Multiple Instances of Excel without PERSONAL.xlsb Lock Message 2009-08-25T16:04:57.127

21 In Excel 2013, where are Visual Basic (VBA), Macros and AddIn tools? 2013-01-13T10:38:10.287

21 How do I add VBA in MS Office? 2014-08-22T14:19:43.033

20 Which Excel objects are zero-based and which are one-based? 2015-10-18T13:00:43.133

16 Any Excel function that will reverse a string? 2010-03-19T02:43:54.257

14 Recover sheet protection password in Excel 2009-09-22T09:02:40.063

14 Adding an element to the end of an array 2014-09-08T14:39:54.450

14 How to filter Outlook email using a Rule with a VBA script? 2015-10-16T19:43:34.727

13 How to inspect / view an Excel macro before "enabling macros" for a sheet? 2013-03-16T16:45:00.213

13 How to remove Document Inspector warning in Excel 2018-04-13T00:08:12.597

12 Where to find a VBA function's source in Excel 2010-03-29T16:00:54.837

12 How do I use a Private Sub in Excel? 2011-07-12T07:01:13.807

12 How to programmatically iterate through subscripts,superscripts and equations found in a Word document 2012-07-19T16:46:13.473

11 Change VBA Editor Color Scheme to something darker 2013-04-19T17:10:54.480

10 How to combine values from multiple rows into a single row in Excel? 2012-02-28T22:05:49.887

10 Custom user function without using VBA 2014-04-17T20:01:31.827

10 Delete ALL custom cell styles EXCEL 2018-02-01T16:46:09.710

9 Excel VBA "Unselect" wanted 2012-09-03T22:07:34.943

8 Select an entire column minus header row in an Excel macro 2009-09-16T19:26:18.967

8 Import json data into Excel 2010-07-08T20:37:26.020

8 Using an external text editor to edit VBA code 2013-01-23T12:29:58.657

8 How can I find out which parts of an Excel workbook are the biggest in size? 2014-04-09T12:36:24.410

8 How do I download a stock price in Excel 2013? Is there an equivalent to Google Doc's GoogleFinance spreadsheet function? 2014-04-23T16:16:56.317

8 Searching for a value in Excel, returning yes or no 2014-05-21T20:08:24.160

8 How to change Control-Y behavior in Excel-VBA's IDE 2015-02-18T20:19:09.800

7 Word: Resize Image by Percent - Macro 2011-12-20T20:35:48.997

7 How to replace text in the body of an incoming message with a hyperlink in Outlook 2010? 2012-08-20T16:32:25.477

7 Extract data from delinked Excel plot 2013-09-26T02:47:49.263

7 How do I install Visual Basic for Applications 2013 in Office 365? 2013-11-24T11:28:15.497

7 How to add custom styles to navigation pane or change them with VBA 2014-09-11T11:17:21.857

7 Remove multiple 'ThisWorkbook' modules from Excel VBA editor 2016-03-03T17:26:20.830

7 Go to a specific slide in powerpoint when creating the slides 2017-02-01T17:33:16.287

7 What is Macro worksheet in Excel? 2017-09-24T12:58:46.810

6 What would an Outlook 2007 macro to automate Paste Special - Unformatted Text look like? 2009-08-18T23:59:24.533

6 Inserting a (jpg) picture into a cell in Microsoft Excel 2007 2010-03-08T20:10:52.577

6 Excel: Update a value in a named range 2010-03-26T13:23:58.500

6 Word 2007 macro gone 2011-02-15T08:20:10.503

6 Use a Trendline Formula to Get Values for Any Given X with Excel 2011-03-08T22:29:10.063

6 Inserting a signature automatically into an Outlook Calendar meeting request 2011-03-11T17:02:26.240

6 VBA Runtime error 1004: Method 'OpenText' of object 'Workbooks' failed 2011-05-27T22:20:20.020

6 How to return everything between two characters in Excel? 2011-07-01T19:55:51.810

6 How do I move the selection down one row in Excel 2007? 2011-10-04T09:18:12.470

6 How do I use Excel 2010 Personal Macro Workbook? 2012-02-11T22:56:52.900

6 How to auto advance a PowerPoint slide after an exit animation is over? 2012-02-13T00:25:37.717

6 How to use the autocomplete feature for VBA function in Excel 2007 with Excel Add-In 2012-07-15T09:11:14.543

6 Create new folder for new sender name and move message into new folder 2012-10-17T20:00:04.250

6 Find and replace multiple values within selected cells 2013-07-16T15:48:31.100

6 Using English macros in French version Excel 2014-01-30T09:33:15.433

6 Call PowerShell script from Excel macro 2014-03-05T13:39:50.803

6 How to create a Call Diagram for Excel macros? 2015-02-09T19:31:33.913

6 Can I customise the new Timeline slicer in Excel 2013? 2015-07-08T16:29:30.980

6 How to find and replace the character “*” in excel text values in cell, but NOT formulas 2015-09-04T19:14:04.273

6 Excel creates non-existent worksheets in VBA Project Explorer 2015-11-25T19:42:45.217

6 How do I get the last worksheet in Excel VBA? 2016-01-08T16:33:15.163

6 Text to Binary with Formula 2017-01-05T15:57:16.887

6 Custom Formula Not Updating 2017-10-22T22:48:07.927

6 Count unique value ignoring Text in range 2018-06-22T07:16:05.760

6 VBA Debugging - step through main program, but run routines called from it? 2019-11-04T19:10:35.610

5 How can I insert the quoted price of gold from kitco.com into my excel spreadsheet? 2010-10-31T03:01:02.743

5 A thousand JPEG images in a Word document: how can I format them in the same way? 2011-05-11T11:12:04.437

5 Excel VBA Function runtime error 1004: Application-defined or object-defined error 2011-06-23T21:47:20.620

5 How to filter source sheet in Excel pivot table drill down? 2012-06-29T21:20:52.033

5 How do I package an Outlook 2010 macro for other users? 2012-08-20T22:12:08.773

5 how to remove or change background fills in all tables in a microsoft word document 2012-12-17T09:34:09.593

5 How can I turn a Calculated Column back into a data column in an Excel Table? 2013-03-20T14:28:22.310

5 Bring back the object browser in Word 2013 2013-04-04T12:58:23.693

5 How to avoid references in VBA (Early Binding vs. Late Binding) 2013-07-04T09:23:04.747

5 Trigger macro with ONE click on specific cell 2013-10-22T10:12:12.420

5 Allowing users to unhide (format) only chosen columns 2014-01-15T14:31:02.803

5 How do I replace all breaks in a selection in Word using VBA? 2014-03-16T12:44:27.003

5 show more than 8 items in the Data Validation drop down list in Excel 2014-06-25T13:50:33.480

5 Excel VBA program only running at 25% speed 2014-07-28T14:55:04.093

5 How can I record a transition from a 0 to 1 in a column in Excel? 2014-12-02T16:21:20.527

5 How can I add / upload bulk entries to Excel 2010 Autocorrect? 2015-08-23T09:15:46.380

5 How do I export all images from Excel and give a name from a related cell 2016-02-29T15:13:49.220

5 VBA that can delete a row from a range where there is no text, although the cell has a formula 2016-11-14T11:09:02.270

5 Pressing a button to cycle through a range's values 2018-06-13T21:57:41.417

5 VBA unavailable from Office programs 2019-02-26T00:20:26.300

4 Excel 2003 macro doesn't see named cell 2010-02-24T23:33:10.643

4 How do I create an Excel Macro to output key/value pairs to file? 2010-10-22T21:01:19.697

4 Excel 2010 Macro "Command could not be completed by using the range specified" 2011-05-17T22:20:57.340

4 Calculating the average of variably sized blocks of numbers within a column? 2011-06-21T12:39:26.513

4 How to increase row height in Excel by X. ie. Add vertical cell padding 2011-08-01T14:23:17.787

4 How to execute a stored SQL procedure in Microsoft Excel? 2011-08-19T09:09:29.003

4 How can I remove the space between dollar sign and value in Excel cell? 2011-10-07T14:20:20.007

4 Read mail attached excel files 2011-11-29T18:34:58.040

4 Can I remove images from an Excel spreadsheet by name? 2012-01-31T05:11:18.220

4 Prevent Excel 2010 user from pasting formatting into cell 2012-02-21T20:15:31.787

4 Excel "super duper" vlookup formula needed 2012-05-07T22:43:08.957

4 Show Excel column filter information in cells 2012-06-14T05:48:34.137

4 How can I split Excel data from 1 column into 8 columns while keeping the data in a specific order? 2012-08-16T14:24:57.677

4 Outlook 2010 - using a VBA script in a rule 2012-09-13T00:11:05.853

4 Excel ran out of resources while attempting to calculate one or more formulas 2013-01-02T10:04:33.417

4 Excel - concatenating cells where reference number matches 2013-03-05T14:52:35.820