Thread
:
How to: assign a value to a cell without selecting the cell first
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett