| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a difference between CTRL+D and CTRL+" (quotation marks) | Excel Discussion (Misc queries) | |||
| How to make Ctrl-C, ctrl-V work in Office 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets | Excel Discussion (Misc queries) | |||
| Redefining the Ctrl [ and Ctrl ]s short cut with OnKey? | Excel Programming | |||
| Disabling Ctrl-PgUp and Ctrl-PgDn | Excel Programming | |||
![vumian[_21_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
