Data into Excel references

[waqas ali]

dear all,

i have stored cell references like $A$1, $B$1:$C$1 in access table. i want to run query and query result want to put in sheet cells address which i have stored in access table these are more than 5000 near to 100000.

for example i get 2000 cell references in query from table now i want to select these cells in excel sheet. can any one give me better idea.

[ranman256]

not clear.
you want to take say record 1, which is $A$1
and fill it with the formula: $B$1:$C$1
??

Normally, Access deals in hard data, not references. You can make Access plug in data into cells, and let Excel contain the formulas.

[Norie]

What exactly do you want to put in the cells on the Excel worksheet?