Snipplr

(Visual Basic) Dictionary loader - lolrenx

Fri, 04 Jan 2013 20:05:22 GMT

short loop to load a dictionary

(Visual Basic) Left of - lolrenx

Thu, 20 Dec 2012 03:03:52 GMT

Left of separator

(Visual Basic) Right of Last - lolrenx

Thu, 20 Dec 2012 03:02:57 GMT

Right of last instance

(Visual Basic) Range to String - lolrenx

Thu, 20 Dec 2012 02:59:14 GMT

Concatenate all text in cells with defined separator

(Visual Basic) Format Header Range - lolrenx

Thu, 20 Dec 2012 02:56:27 GMT

quick way to get column headers formatted

(Visual Basic) Datarange as Class - lolrenx

Thu, 20 Dec 2012 02:53:17 GMT

consider currentregion as a 'datarange' custom class

(Visual Basic) Copy rows based on criteria to a new sheet or file - angelia

Thu, 15 Nov 2012 05:57:12 GMT

Copy rows based on criteria to a new sheet or file

(Visual Basic) 'Append data from multiple worksheet to single worksheet macro - angelia

Thu, 15 Nov 2012 05:54:53 GMT

'Append data from multiple worksheet to single worksheet macro

(Visual Basic) Return File Reference - sjmoorecouk

Tue, 18 Sep 2012 23:01:12 GMT

Used to invoke a GetSaveAsFileName dialogue box

(Visual Basic) Convert Excel plain text links to hyperlinks - kidmizere

Wed, 07 Mar 2012 15:00:09 GMT

Save the following code as a macro and then apply it to the fields you want to convert

(Visual Basic) Summary Numerical Count - sjmoorecouk

Fri, 17 Feb 2012 03:36:19 GMT

Counts numbers and places the result in row 1. To get this populated click an top row (any) cell and click Yes to the following dialogue box. Only uniquely counts number values, not text.

(Visual Basic) Highlight every other row - kidmizere

Tue, 14 Feb 2012 06:48:58 GMT

Awesome shortcut.

(Visual Basic) MS Excel: Remove all images - mikaelpelle

Mon, 08 Aug 2011 19:55:03 GMT

VBA script to remove all the images present in the active sheet of the Microsoft Excel spreadsheet.

(Visual Basic) VBA: Export excel range as image and save as file. - win4me

Thu, 02 Jun 2011 06:36:10 GMT

PROBLEM: How to save Excel range into image file. VBA macro in Excel 2007. SOLUTION: Create an empty chart, paste range image into chart area, and Export as image file. Modify code to suite to your needs.

(Visual Basic) Create a Toolbar in excel - Maikel

Fri, 27 May 2011 18:43:05 GMT

(Visual Basic) Running Access Parameter Queries from Excel - CaptainProton

Tue, 26 Apr 2011 06:23:42 GMT

(Visual Basic) Change Highlight Color Excel 2007 - aianrnoens

Fri, 04 Mar 2011 03:27:14 GMT

Use this code to change the default highlight color for a cell in excel 2007. Right click on the sheet name and click view code, Paste this code into the module that comes up.

(Visual Basic) Excel Copy value from cell with custom format - abhisood

Wed, 16 Feb 2011 10:56:25 GMT

Excel macro to copy values from formated cells. For example: If you have a sheet that has huge numbers in millions for example 1,312,323 and you apply a format to the cell such that only 1.3 is displayed, if you want to copy 1.3 and put it in a database (without the format) use the following snippet. Select all the cells you want to apply this macro and run it. Note: this will convert the cell values to string

(Visual Basic) Excel - import a text file - gritter55

Tue, 18 Jan 2011 06:22:13 GMT

(Visual Basic) Remove a specific character from the end of a Excel cell - TheJasonParker

Fri, 14 Jan 2011 22:09:35 GMT

Replace 'A1' with the cell and '-' with the character you want to remove.