Macros

[Khalil Handal]

Hi,
Need to create a macro so that when cell A2 contains value of 1(for
example) in it, the cursor moves to a new cell address (like D200)

Need also a macro to print a sellection (range of cells) in a spreadSheet.

Thanks in advance
Khali Handal

 

[Markus Scheible]

Hi Khalil,

Need to create a macro so that when cell A2 contains value of 1(for
example) in it, the cursor moves to a new cell address

(like D200)

for example:

If Range("A2").Value = "1" Then Range("D200").Activate

Need also a macro to print a sellection (range of cells)

in a spreadSheet.

try:

Selection.PrintOut Copies:=1


By the way: the Macro recorder is perfect for these sort
of questions ;o)

Best

Markus

 

[Don Guillett]

or
if range("a1")=1 then range("d200").select