Using selection with cells.find

[maroon1]

Hello everybody!

Another problem for me today... with this code:

Please Login or Register  to view this content.

Here I tried to keep the selection in "pl" in order to use it after for example like that:

Please Login or Register  to view this content.

It doesn't work and I need help please!

[kalbasiatka]

Hi. Show file and explain what you want to get in the end. Maybe the solution will be completely different from what you had imagined.

[maroon1]

Hi kalbasiatka! Thanks for your answer!!

So in this part:

Please Login or Register  to view this content.

The user enter a year in the inputbox, for example "2010" (step 1). The header "2010" entered by the user is selected in the data table(step 2). The corresponding column is selected (step 3). In the step 4 I tried to put the address of the selected column in a variable "pl" (step 4) because I need to use it after.

I mean here :

Please Login or Register  to view this content.

where I need to use "pl" (the address of the selected column) to apply a "scripting.dictionary" on the selected column. So use the corresponding
column address with Range ().

I don't know if this explication is better? thank you again for your help!

[kalbasiatka]

Maybe so?

Please Login or Register  to view this content.

[maroon1]

Re,
I tried like that but it doesn't work!

Please Login or Register  to view this content.

In fact, I need to set the "dictionary" with a range of cells, which are selected by the user through ".cells.find()".

[kalbasiatka]

Do not understand why such manipulations

[maroon1]

Because I begin! ) Thank you very much for your help!! That works!! and I have to find where I made my mistake

Thanks a lot!!