Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

excel api command line mysql database windows file error text date sort validation sql server web table forms copy update user find query form array resize printing dropdown list image data links convert number search images format color function ie code directory csv email class header Net login c%23 c%2B%2B java python xml regex facebook uk help support files path flash cheap 3 apache ajax Business android wordpress actionscript c service animation background body customer category Development event best Online download cakephp template security browser url design link extension Oracle rental post

Welcome To Snipplr

Everyone's Recent Visual Basic Snippets Tagged excel

« Prev 1 2 Next »

Visual Basic Excel Copy value from cell with custom format

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...

excel

1 1414 posted 14 years ago by abhisood

Visual Basic Excel - import a text file

excel

0 1075 posted 14 years ago by gritter55

Visual Basic Remove a specific character from the end of a Excel cell

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

excel

0 1364 posted 14 years ago by TheJasonParker

Visual Basic Remove all data connections from Excel Workbook

Code is VBA...

excel

0 8024 posted 14 years ago by dotNetkow

Visual Basic Remove Hyperlinks from Excel document

excel

0 953 posted 15 years ago by a1ias

Visual Basic Excel: Run Macro on Cell Change

The easy way to set this up is to go to the macro window by pressing alt+F11. Select the sheet from left panel. there will be two drop down. from the left drop down select worksheet and from right drop down list select the event 'change'.

excel

0 1253 posted 15 years ago by derekholmes

Visual Basic Find duplicate cells in excel column

excel

0 1086 posted 15 years ago by a1ias

Visual Basic Look up all occurences and merge results (consolidate)

Say you've got data combined in such a way that there is a repeated row header, but all the data is in different rows. If you were to consolidate all the rows down to one, only taking valid values (discarding blanks), you'd have one header row with a...