Add data to different worksheets in same workbook

[NewGuy100]

How do I add data to different worksheets in same workbook using vba. I tried different variations but I keep getting an error. I want to insert data in different cells of the worksheets

[JNW]

Are you copying or using the code to put new data in a cell?

"NewGuy100" wrote:

>
> How do I add data to different worksheets in same workbook using vba. I
> tried different variations but I keep getting an error
>
>
> --
> NewGuy100
> ------------------------------------------------------------------------
> NewGuy100's Profile: http://www.excelforum.com/member.php...o&userid=27935
> View this thread: http://www.excelforum.com/showthread...hreadid=475150
>
>

[Otto Moehrbach]

What you want to do is not clear. Specifically, what do you mean by "add
data to different worksheets"? Post back and provide details about what you
have and what you want to do. HTH Otto
"NewGuy100" <[email protected]> wrote
in message news:[email protected]...
>
> How do I add data to different worksheets in same workbook using vba. I
> tried different variations but I keep getting an error
>
>
> --
> NewGuy100
> ------------------------------------------------------------------------
> NewGuy100's Profile:
> http://www.excelforum.com/member.php...o&userid=27935
> View this thread: http://www.excelforum.com/showthread...hreadid=475150
>

[NewGuy100]

Took me a while but i figured it out. Thanks anyway. Got another question for you though. How can I choose a range using vba. For example, I know i want to start out with A1 but when i want to end the range at Column "D" I want my function to return the value of the row.
Like:
Range A1:Dx
where x is the number returned from a function. Is that even possible
It could be anyone of these.
A1:D10
A1:D15
A1:D20
I need these for charting purposes