name an active worksheet
 

I have a workbook with several worksheets. After entering data into selected
sheets it needs to feed into a letter built in one of the worksheets. A
userform on the letter sheet is used to pick which worksheet the data should
pull from. I have visual basic code written so it pulls from one of the
worksheets at a time, but I would like to write code so it goes to whatever
sheet was selected in the userform. I would REALLY appreciate someone's help
with this as I have been struggling with this for weeks now. Thank you!

--
Message posted via http://www.officekb.com

name an active worksheet
 

if the form returns a worksheet name then you could use the INDIRECT() and
ADDRESS() functions to return the data from that specific sheet.

If this doesn't help, please be more specific on how your solution is
supposed to work.

Tieske.

"djshides via OfficeKB.com" <u27164@uwe wrote in message
news:66edc14972f9c@uwe...
I have a workbook with several worksheets. After entering data into
selected
sheets it needs to feed into a letter built in one of the worksheets. A
userform on the letter sheet is used to pick which worksheet the data
should
pull from. I have visual basic code written so it pulls from one of the
worksheets at a time, but I would like to write code so it goes to
whatever
sheet was selected in the userform. I would REALLY appreciate someone's
help
with this as I have been struggling with this for weeks now. Thank you!

--
Message posted via http://www.officekb.com