Working With Cells

INDEX

COLOR

1

Black

2

White

3

Red

4

Green

5

Blue

6

Yellow

7

Fuchsia

8

Light Blue

9

Brown

10

Forest Green

11

Navy Blue

12

Yellow-Brown

13

Maroon

14

Blue-Green

15

Light Gray

16

Gray

Q Type additional VBA code for working with pasted values.

~Q Type CopyRange.Copy Destination:=Range("A1:B5"), replacing Range("A1:B5") with the range where the copied cell values should be pasted.

Q Type additional VBA code for working with pasted values.

□ Switch to Excel and run the macro.

■ The specified range of cells is copied and pasted in the new location.

□ Switch to Excel and run the macro.

■ The specified range of cells is copied and pasted in the new location.

0 0

Post a comment