Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I'm trying to assign a cell value to a variable, and I keep getting a "Run-Time error '1004': Application-defined or object defined error"
I have a column number, 60, assigned to a variable called "DropDown_txt" I have a row value assigned to a variable called "i" I would like to assign the value in that cell reference to a variable. Here is my code that is giving me the above mentioned error: Code:
ComboVal = Sheets("DATA").Cells(i,DropDown_txt).value Code:
ComboVal = Sheets("DATA").Cells(i, 60).value Code:
ComboVal = Sheets("DATA").Cells(i, "BH").value |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
trouble assigning array to variable (variant) runtime error 9 please help (ignore correction, this didn't appear for some reason) | Excel Programming | |||
Runtime error 9 subscript out of range - assigning array to variable | Excel Programming | |||
Macro giving runtime error on one PC and not another | Excel Programming | |||
Macro giving runtime error on one PC and not another | Excel Programming | |||
Excel help giving runtime error | Excel Discussion (Misc queries) |