Add data to different worksheets in same workbook
 

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

Add data to different worksheets in same workbook
 

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

Add data to different worksheets in same workbook
 

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" wrote
in message ...

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

Add data to different worksheets in same workbook
 

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


--
NewGuy100
------------------------------------------------------------------------
NewGuy100's Profile: http://www.excelforum.com/member.php...o&userid=27935
View this thread: http://www.excelforum.com/showthread...hreadid=475150