Load array with cell location (Excel xp, Win2000)

Topic

New Reply

I want to search a worksheet for the word “GRAND TOTAL” and every cell that has these words in it, i want to load to an array(i). If the words GRAND TOTAL are in cells A41, I41, Y41, Q42 how do i get the A41 from Range(“A41”).select into the array?

array(0) = “A41”
array(1) = “I41”
array(2) = “Y41”

thanks for the help. I really appreciate all the great help i get here. thanks again

Reply | Quote

Replies

Try:

    array(0) = Range("A41").Address

Reply | Quote

Thank you. Once i have the array loaded I just want to extract the numbers of the cell. A41, A2424, i want to load another array with num(0) =41 and num(1)=2424. I’ve tried val(“A41”) but that doesn’t work. Thanks

Reply | Quote

Don’t use the address property, use the row property which gives you just the row number. –Sam

Reply | Quote

ok, it didn’t work with address property so i’ll try row. thanks a lot

Reply | Quote

The code I posted to you in This Message does exactly that.

Reply | Quote