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.

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.

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.

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.