Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged excel

Concatenate all text in cells with defined separator
0 1565 posted 13 years ago by lolrenx
quick way to get column headers formatted
0 1502 posted 13 years ago by lolrenx
consider currentregion as a 'datarange' custom class
1 2634 posted 13 years ago by lolrenx
Copy rows based on criteria to a new sheet or file
0 1941 posted 13 years ago by angelia
'Append data from multiple worksheet to single worksheet macro
0 1654 posted 13 years ago by angelia
Utility class that abstracts the creation of a Excel spreadsheet through Interop, and helps on adding and format its contents.
1 2665 posted 13 years ago by denakitan
Used to invoke a GetSaveAsFileName dialogue box
0 1395 posted 13 years ago by sjmoorecouk
Assuming that cell E15 contains a Belgina code consisting of four numbers
0 1619 posted 13 years ago by shahways
Save the following code as a macro and then apply it to the fields you want to convert
0 2080 posted 14 years ago by kidmizere
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.
0 1302 posted 14 years ago by sjmoorecouk
Awesome shortcut.
0 1574 posted 14 years ago by kidmizere
0 2648 posted 14 years ago by silentpro
In Excel, the Transpose function returns a transposed range of cells. For example, a horizontal range of cells is returned if a vertical range is entered as a parameter. Or a vertical range of cells is returned if a horizontal range of cells is enter...
0 2092 posted 14 years ago by palimadra
0 1905 posted 14 years ago by stur
VBA script to remove all the images present in the active sheet of the Microsoft Excel spreadsheet.
0 1639 posted 14 years ago by mikaelpelle
If you want to export some utf-8 data into csv/tsv that will be readable by excel with correct encoding you must add special non vissable characters at the begining of file
1 3309 posted 14 years ago by dsoms
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.
0 5845 posted 14 years ago by win4me
0 1509 posted 14 years ago by Maikel
http://p2p.wrox.com/excel-vba/65142-sum-group-values-based-cell-criteria.html
0 1623 posted 15 years ago by hairajeshk
It's easy to export several data sets to one Excel spreadsheet with each data set in a separate worksheet.This example exports three SAS data sets (work.region, work.county and work.district) to the same spreadsheet (results.xls).
0 4153 posted 15 years ago by webonomic
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.
0 1615 posted 15 years ago by aianrnoens
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 da...
1 2060 posted 15 years ago by abhisood
0 1031 posted 15 years ago by darfix
0 1490 posted 15 years ago by gritter55
Replace 'A1' with the cell and '-' with the character you want to remove.
0 1883 posted 15 years ago by TheJasonParker
Modify includes to connect and select to provide correct result set
0 3222 posted 15 years ago by kidmizere
Doesn't do any validation, you would want to check if a
0 2843 posted 15 years ago by brettville