Using VB to type something into a cell

  • Thread starter Thread starter petros89
  • Start date Start date
P

petros89

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
 
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.
 
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
Click to expand...
motherboard = Range("C3").value
Sheets("Parts").Range("C3") = motherboard
End Sub
Click to expand...

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