Set a cell value to an object to be referenced for later

[covertp]

Excel 2010 using Visual Basic for Applications code
I am trying to set the value in a cell to the object lookup.

I keep getting error 424

Please Login or Register  to view this content.

[stnkynts]

What do you mean by "object lookup"?

[covertp]

I used the term lookup as a variable to hold the value of the active cell
I have read in many forums you have to declare it as an object to set the active cell value

[covertp]

Ok I found the issue the code is correct but I had cleared all conditional formatting manually and this caused something that created the 424 error. I went back to a previous version before clearing the formatting and it works great.

Thanks anyway.

[covertp]

Ok I thought I had it fixed but I don't

Dim Lookup As Object

ActiveCell.Offset(0, 5).Select

Set Lookup = ActiveCell.Value

Not sure what is wrong. I need the actual value of the cell to be stored in lookup

Any suggestions?

[stnkynts]

Please don't use terminology unless you are absolutely sure you and others will know what it means. There is no "object lookup" as I think you are trying to use it. It sounds to me like you are just trying to hold the value of a specific range, in this situation five columns to the right, same row, of the active cell. If that is the case what you call it is less important than how you declare it. (google search "vba variable declaration") For example:

Please Login or Register  to view this content.