Trying to use the offset function while having the reference cell be equal to a value that a match function has returned. I am getting an object required error when compiling. I realize that the value of the match function I receive is now equivalent to a 'reference cell' for the offset function but I am unsure of how to convert it into one.
Please Login or Register to view this content.
Thre Match function returns an Index number and not a Range or cell.
Try this...
Range("Names").Cells(val,2).Value = x
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
I tried that and I am no longer receiving an error however I added a watch to x and its value remains empty the whole time, thus returning and empty MsgBox
The code doesn't set the value of x to anything, and I have no idea what you're trying to do with it.
I am trying to take the information that I receive from the offset function and display it into a msgbox, I guess I'm just not sure of the best way to go about doing that.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks