select range name from a cell

**Geordie** · 05-05-2010, 02:11 PM

hi

would let to select and copy a range of cells

the range of cells is pre named and the name appears in Sheet("RawData!M1")

i have tried the following with no joy will keep trying

Please Login or Register  to view this content.

was sure about table as integer, tried variant and range

thanks in advance

**Geordie** · 05-05-2010, 02:14 PM

forgot to say the range names will be from PIN1 up to PIN1000

thanks

**Geordie** · 05-05-2010, 04:09 PM

a few people have viewed this but no suggestions yet

thought this would be easy for vba experts

**Geordie** · 05-05-2010, 05:16 PM

please someone help me its now doing my head in trying to solve it

must be possible

please

thanks

**contaminated** · 05-05-2010, 05:37 PM

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button. For more information about these and other tags,

**Geordie** · 05-05-2010, 05:52 PM

corrected code entry

can you help me solve my problem now?

do i need to use indirect?

**contaminated** · 05-05-2010, 06:29 PM

As I understood, u just wanna do simple copy/ paste option thru VBA. right??

Please Login or Register  to view this content.

**mdnghtsnpr** · 05-05-2010, 06:31 PM

A sample workbook would be great to help you out on this but what i did notice is that table name should be string.

**Geordie** · 05-06-2010, 01:52 AM

yes its a simple copy and paste from RawData to Certificate with the range being variable dependingon the contents of RawData!M1

attched a copy of the file

thanks in advance

**Geordie** · 05-06-2010, 02:08 AM

hi just tried to code posted but it doesnt work

any other suggestions

**contaminated** · 05-06-2010, 07:31 AM

what this formula is supposed to do?
=INDEX(INDIRECT(M1),2,1,A6)

what about this one??

Please Login or Register  to view this content.

**Geordie** · 05-06-2010, 07:37 AM

that was just me trying to solve the problem myself - unsuccessfully

the other code you posted doesnt work

i dont want to copy the sheet, just the select range

**Geordie** · 05-06-2010, 07:40 AM

Please Login or Register  to view this content.

tried this first then what you posted

Please Login or Register  to view this content.

then ammeded that to

Please Login or Register  to view this content.

still trying

**Geordie** · 05-06-2010, 07:53 AM

solved it with the following code

Please Login or Register  to view this content.

thanks for all your help

will be in touch if i need anymore help on this project or other projects

select range name from a cell

LinkBack

Thread Tools

Rate This Thread

Display

select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Re: select range name from a cell

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions