LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Member
 
Posts: 70
Default VBA Assigning cell value to variable giving runtime error

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
I've also tried it this way with the same resulting error:

Code:
 ComboVal = Sheets("DATA").Cells(i, 60).value
For some reason, this works with no error:

Code:
 ComboVal = Sheets("DATA").Cells(i, "BH").value
Does anyone have any suggestions as to why this is happening?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
trouble assigning array to variable (variant) runtime error 9 please help (ignore correction, this didn't appear for some reason) mark Stephens Excel Programming 0 July 26th 09 04:52 PM
Runtime error 9 subscript out of range - assigning array to variable mark Stephens Excel Programming 0 July 26th 09 04:20 PM
Macro giving runtime error on one PC and not another Ingrid Excel Programming 2 September 13th 05 07:41 PM
Macro giving runtime error on one PC and not another Jim Thomlinson[_4_] Excel Programming 0 September 13th 05 05:45 PM
Excel help giving runtime error Hari Prasadh Excel Discussion (Misc queries) 1 January 21st 05 01:23 PM


All times are GMT +1. The time now is 03:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"