Search results for query: *

I thought the (( )) brackets was intended to make that portion of the line stand out. Range("Dog").Cells((Range("Dog").Cells.Count)).Activate Range("Dog").Cells(Range("Dog").Cells.Count).Activate The first line was just a little easier to understand...

Thanks for the solutions. I have a question. What do the [ ] around Dog mean? Range("Dog").Cells((Range("Dog").Cells.Count)).Activate or abbreviate to : [Dog].Cells(([Dog].Cells.Count)).Activate

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...

Thanks for the response, The above solution will work in VBA code. Is there a solution that will work in EXCEL as a formula. I would like a formula in the EXCEL spreadsheet return the actual text of a formula.

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...

Ratman had the fix. The key is to set calculation to manual. For some reason auto calculation slowed this macro way down. Here is the fix. New lines shown in red: Application.Calculation = xlCalculationManual Do If ActiveCell.Offset(1, 0) = ActiveCell Then...

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...

Trust_Workbook is assigned a name before the line: Workbooks("Trust_Workbook").Worksheets("Template PVIT").Delete is executed. The execution of this line works, but the ability to step through the macro stops working. I even did a test where I stepped through a small macro...

LoNeRaVeR, Thank you for the help. I tried your suggestion, but it didn't work. I got the runtime error 'subscript out of range'. I cannot put quotes around Trust_Workbook in the line Workbooks(Trust_Workbook).Worksheets("Template PVIT") .Delete because Trust_Workbook is not the...

Yup, I still get the error when I comment out display alerts. I think that something is happening earlier in the macro to cause the ability to step through the macro to stop. This could be more than a code problem, but something to do with how objects are used or modules called. Do you have...

When I am stepping through the macro I step into the line: Application.DisplayAlerts = False and then I step into the line: Workbooks(Trust_Workbook).Worksheets("Template PVIT").Delete That is when I get the "Can't Enter Break Mode at this time" message. I get...

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...