Variables copied into worksheet cells?

[Dave B]

This seems like a really simple question but I can't for the life of me figure out how to copy a variable into a cell.

In other words, say I have a variable with a value of 5. How would I display that value (5) in cell B4 on worksheet "Data"?

Thanks for you help. I've spent about an hour trying to figure this one out so far. Yes, I am a beginner

[mikerickson]

Welcome to the forum.
And welcome to VBA for Excel.

ThisWorkbook.Sheets("Data").Range("B4").Value = 5

is one of the many ways to do what you want.
The VBEditor help system, keyword:"How to reference cells and ranges" is a gateway to the other ways. (May be different keyword in 2007.)

[Dave B]

Thanks, Mike. That's just what I wanted.

Just another quick question. If I substituted the value 5 for a variable name would it still work?

[mikerickson]

What happened when you tried it?