hey guys
just a quick question, when given a column of values, i want to create a function that performs a specific operation for all of the cells, for e.g. add 1 to the value then log it. any tips?
hey guys
just a quick question, when given a column of values, i want to create a function that performs a specific operation for all of the cells, for e.g. add 1 to the value then log it. any tips?
Log it where?
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
A function takes inputs and returns values.
It sounds like the CSE formula =A1:A1000 +1 will do what you want, but the question is where would you like those results displayed.
It seems you're looking for paste special:
http://www.contextures.com/xlDataEntry04.html
[VBA]Sub M_snb()
[A1:A4] = [index(A1:A4+1,)]
End Sub[/VBA]