Search results for query: *

In EXCEL VBA I have a named range and I want to activate the last cell in the range. Example: the EXCEL named range "Dog" is "B6:B25" I want to activate the last cell in the range, "B25". I know Range("B25") will select the cell, but when rows are...

How do I compare two headers on two separate Excel spreadsheets using VBA using range objects? The headers are made up of a range of cells A1:Q3. On Sheet1 I set the header range as the object Range1. On Sheet2 I set the header range as Range2...

This is not a VBA question, but it realates to EXCEL. In EXCEL Is it possible to show a formula as text using spreadsheet functions? For example. In cell A1 I have the Formula = 1 + A3. In cell A5 I want to show the formula as text. I want cell A5 to be "= 1 + A3". Below is what it...

I wrote a macro to go through a list of items and eliminate all repeating items. When I execute the macro it runs very slowly. I can actually make it go faster by stepping through the code. Also, when the code is running, if I hold down the space bar or any character key it runs faster. What is...

In Excel 2000 While in break mode and stepping through a macro, the following message appears when I hit a line of code: "Can't Enter Break Mode at this time". The only options I get are the buttons "Continue", "End" or "Help". The "Debug" button...