how to write Ctrl A in VBA
 

hi everyone,

i have a range which i do not know how many cols and rows before

so, Solution here 1 cell in range is selected before, then do codin
mean Ctrl A, in order to Cells.select

thank yo

--
vumia
-----------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...fo&userid=3649
View this thread: http://www.excelforum.com/showthread.php?threadid=56527

how to write Ctrl A in VBA
 

Why not use


Code
-------------------
Cells.CurrentRegion.Selec
-------------------


vumian Wrote:
hi everyone,

i have a range which i do not know how many cols and rows before

so, Solution here 1 cell in range is selected before, then do codin
mean Ctrl A, in order to Cells.select

thank yo

--
Excelenato

-----------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...fo&userid=3676
View this thread: http://www.excelforum.com/showthread.php?threadid=56527

how to write Ctrl A in VBA
 

hi man,

thank you

--
vumia
-----------------------------------------------------------------------
vumian's Profile: http://www.excelforum.com/member.php...fo&userid=3649
View this thread: http://www.excelforum.com/showthread.php?threadid=56527