Me make a routine / loop / for next for manipulation of lines and columns in excel throu

ME MAKE A ROUTINE / LOOP / FOR NEXT

FOR MANIPULATION OF LINES AND COLUMNS IN EXCEL

THROUGH A MACRO! please

HERE AN EXAMPLE OF HOW TO HANDLE LINES

Sheets ( "lotofacil"). Select
vlin = 1
While the Range ( "a" & vlin) <> ""

vlin = vlin + 1
loop



HERE COLUMNS

vescala = "cdefghijklmnopq"

'FORMAT 02 HOUSES
For i = 1 to 9
Range (Mid (vescala, i, 1) & vlin) .Select
Selection.NumberFormat = "@"
Range (Mid (vescala, i, 1) & vlin) = Format (Range (Mid (vescala, i, 1) & vlin), "00")
Next



HOW DO YOU DO?

Does this help?

Please Login or Register  to view this content.

hello john
THE EXCEL COLUMNS HE BELIEVES IN NUMBERS ??

A = 1

B = 2 .....

Yes. 3 to 17 is c to q