referencing different sheet in code

**maacmaac** · 06-11-2008, 11:05 AM

The following is part of code. This section of code references a range in the active sheet (f:f). I need the code to reference a range in sheet called "list" but can't figure out to modify code (column is still f:f).

Please Login or Register  to view this content.

**Shijesh Kumar** · 06-11-2008, 11:15 AM

Hi,

on the left side of VBA editor you wil find a window which show you all the sheet and their names..
like sheet2 (list)
sheet3 ( abc ) ...

so if the list is sheet2
you can use the following code

Please Login or Register  to view this content.

**royUK** · 06-11-2008, 11:29 AM

Try

Please Login or Register  to view this content.

referencing different sheet in code

LinkBack

Thread Tools

Rate This Thread

Display

referencing different sheet in code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions