Compact approach to refer to range

[YasserKhalil]

Hello everyone
I know this question is so simple and I can do that in several ways
How can I refer to the range O2:O & or by the column number as variable?
In fact, I am trying to search for the most compact way to refer to that range using the "col" variable which equals to 15
I have used this line

Please Login or Register  to view this content.

But this includes the whole column but I need only from the second row to the last row
lrData is the last row as variable

[Fluff13]

How about

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot
I don't need to use the column letter "O" at all. I would rely on the column number variable "col" which equals to 15

[Fluff13]

In that case

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot. This what I did exactly and I though there may be more compact approach. Thanks a lot for sharing.

[nankw83]

How about this ?

Please Login or Register  to view this content.

[YasserKhalil]

That's better nankw83. Thanks a lot

[nankw83]

Glad to help

[Fluff13]

Another option

Please Login or Register  to view this content.

[YasserKhalil]

Thanks a lot Fluff. That's great too.

[nankw83]

Last try :D

Please Login or Register  to view this content.

[YasserKhalil]

Great. Thanks a lot for more suggestions.

[YasserKhalil]

I would use such a fucntion

Please Login or Register  to view this content.

I need your opinion: Is that better to create a UDF for such stuff or this would slow down the performance of the code and it is better to use this directly
I would use a UDF as I need to do such thing for more than 15 times ..
So my question is creating a UDF is better or not?

[nankw83]

If I was in your situation I wouldn't create such UDF because it is just a single line of code & not many lines of code that has to be repeated. In addition, when debugging the code, it would just jump from your code to the UFD which I don't like. In terms of performance, I am not really sure whether or not it slows the code down but you can create a sample file with a large data & do speed test to confirm it in your machine. Perhaps some more experts will share different opinions

[YasserKhalil]

Thanks a lot
I have another idea which is to loop through the variables that I need to create but I don't know if it possible or not

Please Login or Register  to view this content.

But this doesn't create the variables ..How could I create those variables in much easier way?

[nankw83]

You can assign the strings to an array & call it by the array index … Something like below

Please Login or Register  to view this content.

[YasserKhalil]

Thank you very much for the great help.