View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default How to: assign a value to a cell without selecting the cell first

try
cells(1,5)=5
or
range("a5")=5

--
Don Guillett
SalesAid Software

"George Furnell" wrote in message
...
Hi,

Its clear that I am still a newbie...

In VBA, how do I assign a value to a cell with out first selecting the
cell?
In pseudo code I would describe it as "Assign the value 5 to the cell in
location x".

Kind regards

George