a +1 = b?? 1

[AtomicWedgie]

Hello,

how can I get "a" to be raised to "b" and then "c" and so on, is there a function?

Greetz,

Atomic Wedgie

 

[xlbo]

not sure what you wanna do....what application you're using or whether you want to use it in code or in the base app...more info please

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[bryanbayfield]

If you're using Excel then you could just use =(A1)^4^3^2

etc etc

 

[AtomicWedgie]

I am using vba in excell and i want to use it in the code

 

[xlbo]

Do you not have VBA help ??
I just entered "Raise To Power" and got:

^Operator


Used to raise a number to the power of an exponent.

Syntax

result = number^exponent

The ^ operator syntax has these parts:

Part Description
result Required; any numeric variable.
number Required; any numeric expression.
exponent Required; any numeric expression.



Remarks

A number can be negative only if exponent is an integer value. When more than one exponentiation is performed in a single expression, the ^ operator is evaluated as it is encountered from left to right.

Usually, the data type of result is a Double or a Variant containing a Double. However, if either number or exponent is a Null expression, result is Null.


Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[AtomicWedgie]

Hmmm,

what i mean is. How can I program my code so that I can go from cell "A1" to "B1" without doing it hardcoded?

X = a

Range(X1) = Cell A1

X = X + ??????? (so that it becomes b)

Range(X1) = Cell B1

Atomic Wedgie

 

[xlbo]

Use the CELLS syntax
Cells(row,column)


eg

For i = 1 to 10
cells(1,i).select
msgbox selection.address
next i

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[AtomicWedgie]

Thanx Geoff, you are my God

Atomic Wedgie

 

[xlbo]

In that case, I'll need prayers 6 times a day and at least 4 holy days a year when you have to come and serve my every need ;-)

Rgds
Geoff
Si hoc legere scis, nimis eruditionis habes

 

[Stretchwickster]

Geoff...you joker!

It's becoming too easy to get divine status these days ;-)

If the atomic wedgie was caused by this posted problem, Atomic Wedgie, then I'm sure Geoff has alleviated your pain and deserves reward - but a star should suffice cos Geoff is probably just a human too!!!

Clive

http://www.kucu.co.uk

Ex nihilo, nihil fit (Out of nothing, nothing comes)