View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abe[_4_] Abe[_4_] is offline
external usenet poster
 
Posts: 24
Default Fastest way to get keys from collection

I have a dictionary with 200+ keys and picture objects in it.

Each key is a R1C1 style address (i.e. "R4C23"). Each picture object
has a name that is both its type of picture, and the address of a cell
which it is placed over (i.e. pic.name =LLR55C20).

I need to be able to fill each cell with the address in each key of the
dictionary with a formula. Whats the fastest way to do this?

This...

Dim aryKeys
dim i as integer

aryKeys = dict.keys
For i to (dict.count - 1)
range(aryKeys(i)).formulaR1C1 = "X"
Next

....Wouldnt work because the key is in R1C1 style and range takes A1
style, right?