MySQL: Assign Record Set to Variable?

[DHS100]

Hi,

Using the following code I am able to get the number 5 to appear in cell A1:

With Worksheets(1).Cells
.ClearContents
.CopyFromRecordset rs
End With

What I'd actually like to do is get this number into a variable called MyVar. I know I'm being stupid but I just can't figure it out...any help appreciated.