Formatting spreadsheets from Access database 1

JoanieB · Aug 29, 2001

I know this is wrong, but I have received 5 different answers to this and none of them work!

objASht.Range("C1&quot

.Select
With Selection
?.Text = "DTC All Report"
End With

*Where objASht is the active sheet

How can I send the text value to the cell specified?

jebry · Aug 29, 2001

Hi!

Try this:

With objASht.Range("C1&quot

.FormulaR1C1 = "DTC All Report"
End With

I am assuming that you will need to do other things with objASht.Range("C1&quot

. If not the just use objASht.Range("C1&quot

.FormulaR1C1 = "DTC All Report".

hth
Jeff Bridgham

Databaseguy · Aug 29, 2001

objAShtl.Range("c1&quot

.Select
objASht.ActiveCell.FormulaR1C1 = "DTC All Report" Tyrone Lumley
augerinn@gte.net

JoanieB · Aug 29, 2001

You are the man! Such a little, stupid thing, but it's been driving me crazy all day!
You've helped me out before, so THANKS ALOT!