Macros

M

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
Click to expand...
(like D200)

for example:

If Range("A2").Value = "1" Then Range("D200").Activate
Need also a macro to print a sellection (range of cells)
Click to expand...
in a spreadSheet.

try:

Selection.PrintOut Copies:=1


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

Best

Markus
 
Top