Run Time error 9 Subscript out of range

[kaseyleigh]

Hi

I get Run Time error 9 Subscript out of range, I cannot see where the error is
Please may I ask for some advice?

Much appreciated!

Please Login or Register  to view this content.

[vcoolio]

Hello KaseyLeigh,

That particular error usually means that the code cannot find where it it supposed to copy or paste or transfer data to/from.

I suspect that this line is your problem:-

Please Login or Register  to view this content.

You have not specified a range to paste the formula to,e.g. Range("A2:A20").

You may have to post your whole code, just in case.

Cheerio,
vcoolio.

[vcoolio]

...............or you could try this:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[vcoolio]

...............or you could try this:-

Please Login or Register  to view this content.

I hope that this helps.

Cheerio,
vcoolio.

[vcoolio]

....and i have no idea why it posted twice!

[Norie]

Do you definitely have a sheet with the exact tab name 'Sheet1'?

[kaseyleigh]

Hi lovely people

Mmm ... changed my code to select the cell User picked then next line of code is ..

Please Login or Register  to view this content.

and I get Run time error 1004 Application-defined or object-defined error ..... eeeeeek!

[Norie]

Can you post the rest of the code as it is?

Also, an explanation of what you are trying to do would help.

PS If you just want to put =1+1 in the user selected cell you could use this.

Please Login or Register  to view this content.

[kaseyleigh]

Hi Norie (thanks for your time!)

Here's my full code.
I am copying a formula and want User to pick a cell to paste the formula into

Please Login or Register  to view this content.

[Norie]

Where do you get the error with that code?

[kaseyleigh]

at Line myCell.Formula = " .......


basically I want formula =VLOOKUP([@[Fund Name]],PKRFactsheetSelection.asp!$A:$F,6,FALSE) inserted into cell user picks

[kaseyleigh]

Norie

it works I was being a div "DOH!"

Thank you for your time and knowledge!