How to add cells to range?

[adds007]

Hi,
I am fairly new to VBA
This is probably easy, but I can;t figure it out lol

Can someone provide me a code such that I can add items to range?

For example, the function code shuold loop through one of the columns and add that cell to a range, if they contain a value in it (doesn;t matter which value).

thanks

[royUK]

Not sure what you want. You should certainly avoid Loops when possible.

Look at UsedRange or CurrentRegion in the VBA Help

[adds007]

Hi again,
I have attached an example of what I want to do.

You can click the boxes to put checkmarks or select a block of cells(if there is a faster way, i am all open)
What I want to do is declare a range object, then store the cell addresses (not the values inside it) to that range
So that I can work with the rows that are checked.

[royUK]

You would be better saying what you need to store the addresses for,you will probably get a more efficient answer.

[adds007]

Sorry about that
At my work I have been told to make a macro to compile a cable list.
The cable list tho contains all types of cables.
So I already made the option for user to select cells that they want to compile a list for (using checkmarks)

So now I am working on a program which basically checks for all the "checks" and compile a list for only those cables (checked ones).

I tried using UsedRange or CurrentRange, but none of do what I want

[shg]

Please Login or Register  to view this content.

[adds007]

Sorry for late reply
I have to go somewhere, but I tried the code u posted just before u left and it seems to do what I want!!
I will work on it after I am back and will let you guys know

THANKS a lot

[adds007]

YES!!!!
IT WORKED!!!!!
thanks a lot