counting in letters

thanks and sorry about the wrapping, I didn't know how to do that until you replied. I will try your suggesting and see if this helps. THanks again.

Originally Posted by VBA Noob

Thanks for wrapping code.

Maybe

Dim Rw As Long, Col As Long
For Col = 1 To 4
    For Rw = 1 To 10
        Cells(Rw, Col) = Rw & "," & Col
    Next Rw
Next Col

VBA Noob

How does this feature work when I am referencing other sheets? Could you give me an example of how to do this as well?

my goal is to place equations into cells that reference other sheets cell locations. i know this is wrong but something like this:

Dim Rw As Long, Col As Long
For Col = 1 To 4
    For Rw = 1 To 10
        sheets1.Cells(Rw, Col) = sheets2(Rw & "," & Col)
    Next Rw
Next Col

Plus I want the sheet# to be a variable so I can count through the sheets. I hope this makes sense.

I didn't include formulas because they are massive and lots of them. There are over 20 formulas but here is an example of one.

=IF(RC2>R21C5,0,-A2!R[-100]C8*A2!R5C3*R101C6)

A2 is the name of the sheet that it is referencing. this is just one of many formulas as this workbook is massive. thanks for the help.

The excel function

= ADDRESS(column, row)

does exactly what I want. However, I want to use this function inside of a macro. I have tried both of the following lines but neither works.

variable = Application.Address(column, row)
variable = Application.WorksheetFunction.Address(column, row)

Does anyone know what I am doing wrong here?

If you want to return a Range as a variable, you have to use the set command. There may be better ways to do this, but it is difficult to give you an answer without seeing your code and knowing what you ultimately want to do.

Originally Posted by BigBas

If you want to return a Range as a variable, you have to use the set command. There may be better ways to do this, but it is difficult to give you an answer without seeing your code and knowing what you ultimately want to do.

The Address function returns the address of the given numbers. Example: Address(2,2) returns $B$2

I simply want to do this in a macro. I want to feed a variable the address of 2 coordinates and have it store that value.

variable = Address(2,2)
Range("A2").value = range(variable).value

If the cell $B$2 contains the value 8, I would expect the value of 8 to now be in cell A2. Does that help?

Originally Posted by VBA Noob

Soce,

Threads merged as per forum rules.

As I said if you want a proper answer give a proper example

VBA Noob

Does my example above help? I simply want to use the function ADDRESS inside a macro. How do I do so? It works perfectly fine in my excel spreadsheets but does not work in the Macro.