| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sharing Data between worksheets within in one workbook | Excel Worksheet Functions | |||
| Getting data from different worksheets in another workbook | Excel Discussion (Misc queries) | |||
| How do I sort data from various worksheets in the same workbook i. | Excel Worksheet Functions | |||
| data refresh all worksheets in a workbook using vba | Excel Programming | |||
| Help exporting worksheets/data to a workbook. | Excel Programming | |||
![NewGuy100[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
