View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
petros89[_4_] petros89[_4_] is offline
external usenet poster
 
Posts: 1
Default Using VB to type something into a cell


Hi, I'm using VB to produce a macro which types the number "1" into
cell..

So far I have:

Sub deleteme()
'
' deleteme Macro
' Macro recorded 29-11-2005 by Petros Poullaides
'

'
Range("C3").Select
motherboard = Range("C3")
Sheets("Parts").Range("C3") = motherboard
End Sub

but it just deletes the value in cell C3....how do i make it type "1
in cell C3?

Please help as it is for my schoolwork..
Thanks in advance.

Petro

--
petros8
-----------------------------------------------------------------------
petros89's Profile: http://www.excelforum.com/member.php...fo&userid=2464
View this thread: http://www.excelforum.com/showthread.php?threadid=48904