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:
inna_90 la Simpatie.ro

Femeie
23 ani
Vrancea
cauta Barbat
30 - 48 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] VBA Code to Show Range Address in MsgBox

Pagini: 1

Moderat de TRaP, TonyTzu

TRaP
Moderator
Postari: 964

Instead of:

MsgBox rng

which errors of course, use:

MsgBox rng.Address(ReferenceStyle:=xlA1)

Source:
https://www.exceldemy.com/excel-vba-msg ... e-address/

Topicuri similare

[EXCEL] VBA to Print Range Values to MsgBox
[EXCEL] If MsgBox No Button Pressed Exit Sub
[WORD] Word VBA Code Samples
[ROUTER] How to find out your router or modem IP address
[EXCEL] Create Hyperlink to Cell Address [HYPERLINK]
[FIREFOX] Menus that can be accessed from address bar

Pagini: 1

Mergi la