Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Nou pe simpatie: mimy_glacier pe Simpatie
 | Femeie 24 ani Prahova cauta Barbat 26 - 47 ani |
|
|
Mrrrr's Forum (VIEW ONLY)ReguliInregistrareLoginPozeNu sunteti logat. Lista Forumurilor Pe Tematici
|
| #1 |
TRaPModerator
Postari: 960
|
|
Create a new module in your PERSONAL.XLSB file:
Sub ToggleR1C1() Application.ReferenceStyle = _ xlA1 + xlR1C1 - Application.ReferenceStyle End Sub |
Add this macro as a button on your Quick Access Toolbar (QAT). Every time you click on that button it will switch column references from A-B-C style to 1-2-3 style (R1C1).
|
|
| |
|
| #2 |
TRaPModerator
Postari: 960
|
|
|
| |
|