Defined SheetValue as Variant, but it still says object required?

Hi Guys

(Problem solved, thanks for your time!)

I'm trying to process a table so that I can create a cvs file...

Data:
The data I have looks like this... where username either has or has no access to that system.

....................System1......System2... System3
Username1.....Yes.............No............No
Username2.....Yes.............Yes...........No
Username3.....Yes.............No............Yes

VBA Error:
The error I'm having is "Object required" for SheetValues in the line highlighted in the code (which I defined as variant). Please note that the first line of the code below works fine and the data is loaded correctly. I can view it in my watch console.

This is what my code looks like

Please Login or Register  to view this content.

Is the error occuring because I'm trying to invoke Value from a variant object? If so, how do I correct this?


**************************************************

oh, after an hour of trial and error, I figured this out...

I changed the SheetValues to Range instread of Variant... then I used the keyword Set to set the values and removed .values from the first line above...

Please Login or Register  to view this content.

Now the file is created, but it is a hotmess :D .. I will still need to play with the code to make it do what I want...

If anyone has any suggestions to make the code cleaner... I'm happy to read your suggestions!

Thanks
Dan