Macro - input sheet selection

**bobboy** · 02-19-2007, 03:46 PM

What do I subsitute or use in a macro to change a sheet reference I selected manually, i.e. Sheets("Sheet1").Select to take the reference in a cell for the sheet name?

Thanks

**VBA Noob** · 02-19-2007, 03:52 PM

Hi,

Do you mean you want to rename the active sheet to say the value in cell A1for example??

VBA Noob

**VBA Noob** · 02-19-2007, 03:56 PM

If that's what you meant then try

Please Login or Register  to view this content.

VBA Noob

**bobboy** · 02-19-2007, 04:36 PM

No. I want the macro to input data from the active sheet to the sheet name that is identified in cell c4 on the active sheet. I will have a number of sheets with various names which will be identified in C4. Cell C4 and other cells are populated by a dropdown box and manual data entry. That info will be will be transferred the sheet selected in C4 by a enter button. Other sheets will be populated with similar data so the sheet name is the key.

Thanks and sorry for not describing it clearer.

**VBA Noob** · 02-19-2007, 04:42 PM

Think you need to give more info.

E.g If say C4 value in activesheet is Sheet2 then what range are you copying and where will it paste to within Sheets??

VBA Noob

**bobboy** · 02-19-2007, 04:53 PM

Here is the Macro. Just need it to enter on the sheet identified by C4

Please Login or Register  to view this content.

**VBA Noob** · 02-19-2007, 05:20 PM

Please wrap your code in future. I've done it on this occassion

Addition's in bold

Please Login or Register  to view this content.

**bobboy** · 02-19-2007, 05:34 PM

It's obvious I have little knowledge of macros. What do yo mean by wrap code with the # symbol, for Macros or this thread?

Thanks Again!

**VBA Noob** · 02-19-2007, 05:42 PM

There is a symbol on the toolbar which looks like a #. When adding code to this site you should click on the symbol and paste your code between

VBA Noob

Macro - input sheet selection

LinkBack

Thread Tools

Rate This Thread

Display

Macro - input sheet selection

Macro - input sheet selection

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions