Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Hondo Chalthoum on Jan 31 In MS Office Category.

Listing named cells

Question Answered By: Brooke Robertson on Jan 31

Someone is misleading you.

When you add a workbook like that, it DOES become active. Try this

MsgBox ActiveWorkbook.Name
Workbooks.Add
MsgBox ActiveWorkbook.Name

This Question has 8 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Listing named cells Or get search suggestion and latest updates.

Related Topics:

Copying current cell's value to another cell
Select random cell in list and highlight contents
drop down list for a cell
Insert user name in cell
identifying sheet name from the cell
Macros and Named cells
making a spreadsheet cell name a global variable in the VBA project
how are cell coordinates referenced on a clicked cell
to see if text in a cell in a column is contained in any cell
Copy cell contents to same cell on different worksheet if contains
Cell validation based on the contents of previous cell
A Paragraphs in one cells --> convert into a line in per cells
active cell no longer advances to cell below
Update a cell based on a DDE updated cell value
Moving data in the last cell of row to another column cell
Action taken by Excel when a condition causes a cell's value
Function needed to split the content of a cell intomany cells
Function needed to split the content of a cell into many cells
Copy Value produced by formula in cell C3 to cell D3
Finding and replacing the cell next to a cell with a certain string

Tagged:listing named cells

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us