Menu

Help! Selecting a Worksheet with VBA

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.programming

[email protected] yonathan.sabbah@gmail.com is offline

yonathan.sabbah@gmail.com is offline

external usenet poster

Posts: 5

Default

Help! Selecting a Worksheet with VBA

wrote:
Hello,

Ok we all know that I can select a sheet on Excel by doing:
sheets("Name").select or worksheets("Name").select

But my problem is that I take the name from a cell with something like:

Dim Name as String
Name = Range("A1").value

If I now do:
sheet(Name).select

I get an error (Name as to be an Object, not a string). I can I do
this? It shouldn't be that hard to select a sheet from a cell value!

Damm VBA!

Regards,

Yona

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Selecting a row in a worksheet	Rochelle in Melbourne	Excel Worksheet Functions	1	April 9th 09 11:34 AM
Selecting Next Worksheet	Fleone	Excel Programming	3	May 2nd 06 05:05 PM
selecting a worksheet	rocket0612	Excel Worksheet Functions	2	March 1st 06 09:47 AM
selecting cell range in other worksheet without switching to worksheet	suzetter[_4_]	Excel Programming	4	June 22nd 05 08:55 PM
Selecting Last Worksheet	Alex	Excel Programming	7	September 26th 04 09:35 PM

All times are GMT +1. The time now is 05:00 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement