Advanced Search

Welcome To Snipplr

Everyone's Recent Visual Basic Snippets Tagged excel

1 2 Next »
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 1888 posted 14 years ago by abhisood
0 1347 posted 15 years ago by gritter55
Replace 'A1' with the cell and '-' with the character you want to remove.
0 1715 posted 15 years ago by TheJasonParker
Code is VBA...
0 8727 posted 15 years ago by dotNetkow
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'.
0 1528 posted 16 years ago by derekholmes
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...
0 1256 posted 16 years ago by pckujawa
0 1368 posted 17 years ago by goo
0 1552 posted 17 years ago by Wardy
0 1167 posted 17 years ago by goo
A basic function to return the last used row for a given row
0 1323 posted 18 years ago by fabboi03
MS Excel Macro para escribir números en letras
0 1449 posted 18 years ago by j_junyent
0 2134 posted 18 years ago by corydeppen
1 2 Next »