Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

a bizarre thing - Ctrl+A

  Asked By: Koila    Date: Jan 01    Category: MS Office    Views: 563
  

I know this may be a stupid question, but I have to ask anyway.(this
may add the stupidity...)

I created two new workbooks - book2 and book3. The inital active
workbook is book2. F2 is actually an empty cell and Column A can C
are populated.

I pressed Ctrl+A -> Ctrl+C -> go to books ->Ctrol+V.And then Alt+F11.

The operation went well. I chose everything on that activesheet of
workbook2 adn then copied it to book3.

When I Alt+F11, I can't see where is "Ctrl+A". I was expecting
something between <Range("F2").Activate> and <Selection.Copy>. For
me, it looks like the code will only copy F2, but in fact, it chose
the whole sheet and made copy of it.

Then, where is Ctrl+A?

Below is the recorded macro.

Sub Macro2()

Cells.Select
Range("F2").Activate
Selection.Copy
Windows("Book3").Activate
ActiveSheet.Paste
End Sub

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Eric Foster     Answered On: Jan 01

Selecting all the cells is in the "Cells.select" command. The
"Range("f2").activate" is basically just telling Excel where to put the
cursor.

 
Answer #2    Answered By: Oliver Evans     Answered On: Jan 01

The problem is: I chose F2 before I pressed  Ctrl+A, how come the
cells.select is even before Range("F2").Activate?

 
Didn't find what you were looking for? Find more on a bizarre thing - Ctrl+A Or get search suggestion and latest updates.




Tagged: