Thread: how to write Ctrl A in VBA
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Excelenator[_2_] Excelenator[_2_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote