Number above next Cell

  • Thread starter Thread starter Roby
  • Start date Start date
R

Roby

Have a Sheet with codes :

A B C D C
1 T G G G 12
2 G G G T 11
3 G G T T 23

(each Cell is 16x16 pixels)
The G's and T's are codes (Format as "T 12" (Letter-Space-Space-Number))
The Number part should be hidden under the next Cell but in each line the
last
Cell it is above this Cell.

Want it to be like this :

A B C D C
1 T G G G
2 G G G T
3 G G T T


Anybody ?
 
Well, you could use VBA to put a space character in the cell to the
right...

Range("G2:G" & Range("A" & Rows.Count).End( _
xlUp).Row).FormulaR1C1 = " "
 
To be correct the Ranges are :

D9:X31
D45:58
D82:X93

Codes are: T 1 till T31 and G 1 till G 31

What would be the correct line in VBA ?
 
Back
Top