Hi Petros,

Your question is unclear.

What is 'motherboard'.

To enter the value 1 in C3, try:

Range("C3").value = 1


If this is not what you intend, then please supply additional information.

---
Regards,
Norman



"petros89" wrote in
message ...

Hi, I'm using VB to produce a macro which types the number "1" into a
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.

Petros


--
petros89
------------------------------------------------------------------------
petros89's Profile:
http://www.excelforum.com/member.php...o&userid=24645
View this thread: http://www.excelforum.com/showthread...hreadid=489047