Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy way to plus 10 to each cell in A1:A50?
Is there an easy way to do an operation to a row, colum or a selection?
For example, want to plus 10 to each cell in A1:A50. Thank you. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy way to plus 10 to each cell in A1:A50?
I prefer a non programming way because this is such a simple common
operation. But any suggestion, programming or not, are welcome. Thank you. muster wrote: Is there an easy way to do an operation to a row, colum or a selection? For example, want to plus 10 to each cell in A1:A50. Thank you. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy way to plus 10 to each cell in A1:A50?
Dim Cell As Range
For Each Cell In Range("A1:A50") Cell.Value = Cell.Value + 10 Next Cell non-VB you would need to use an empty column (or insert a column), e.g. col "B". In "B1" put the formula "=A1+10" then drag "B1" down to row 50. When done you could delete col "A" if necessary. "muster" wrote: I prefer a non programming way because this is such a simple common operation. But any suggestion, programming or not, are welcome. Thank you. muster wrote: Is there an easy way to do an operation to a row, colum or a selection? For example, want to plus 10 to each cell in A1:A50. Thank you. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Easy way to plus 10 to each cell in A1:A50?
In a blank cell type the number 10
Now copy the cell Highlight the range that needs to be added to Right click inside the highlighted range and Paste Special In the operation part, highlight the Add radio button and click OK Click anywhere to remove the highlighting and press Escape to remove the marching ants from around the copied cell -- Saruman --------------------------------------------------------------------------- All Outgoing Mail Scanned By Norton Antivirus 2003 --------------------------------------------------------------------------- "muster" wrote in message ups.com... Is there an easy way to do an operation to a row, colum or a selection? For example, want to plus 10 to each cell in A1:A50. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
easy one - multipule formulas in one cell | New Users to Excel | |||
An easy way to delete spaces in a cell... | New Users to Excel | |||
easy one - select a cell | Excel Programming | |||
Easy question - If ...then Change cell value | Excel Programming | |||
new user with easy question? not easy for me | New Users to Excel |