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

Using VB to type something into a cell
 

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

Using VB to type something into a cell
 

You just about got it, but need to set the motherboard variable to the Value
of Range("C3"). BTW, in -most- cases, .Select an object to work with it is
unneccessary and merely slows your code down.

try this:
Sub deleteme()
' Macro recorded 29-11-2005 by Petros Poullaides
motherboard = Range("C3").value
Sheets("Parts").Range("C3") = motherboard
End Sub

which does the same as: Sheets("Parts").Range("C3") =Range("C3").value

"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