how to write Ctrl A in VBA

[vumian]

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

 

[Excelenator]

Why not use


Code

 

[vumian]

hi man,

thank you

 

[AmjiBhai]

You may Use sendkey function in vba