View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Neil K Neil K is offline
external usenet poster
 
Posts: 3
Default reading data from com port into excel spreadsheet

Hi Evelien,

Thanks for the response. My variable is "RB" for the buffer coming in.
Would I just use your code and instead of text, put

Cells(5, 3) = RB
??
Thanks
Neil

"Evelien Snel" <Evelien wrote in message
...
Hi Neil,

"Neil K" wrote:
[...]
each time the data from the com port can be put into these same cells.
Can
I put data into a cell without selecting it?


Yes You can. Try this:

Sub FillInCell()
Cells(5, 3) = "Hello, World!"
End Sub

Success!