activate

Folks, How do I replace all selections with activations in this code: 'Delete Filtered Rows (how to remove selection?) Range("a2", Selection.SpecialCells(xlCellTypeLastCell)).Select Selection.SpecialCells(xlCellTypeVisible).Select Selection.EntireRow.Delete I tried skipping...

Folks, How do I change this code so that it does not have to select the cells, but can activate them instead? 'Delete Filtered Rows Application.CutCopyMode = False Range("a2", Selection.SpecialCells(xlCellTypeLastCell)).Select Selection.SpecialCells(xlCellTypeVisible).Select...

Hi. I have a workbook with about 140 sheets. I would like to have a macro that activates one of those sheets, based on their name selected from a drop down cell. Example: I have a drop down cell with pre defined names (for instance A, B or C). I have three sheets named the same (A,B or C). I...

Hi all, I hope someone can help me... I have some code which looks at each cell in the selected range, and if the cell value is higher than that of row 3 of the same column, it will add a comment to that cell. It currently works but only now I have made the loop activate each cell - but I'm...

This error message pops up when I run the macro, "Run-time error '9': Subscript out of range" I was wondering what could be wrong with the code? "Sheets(sheetName).Activate" is highlighted. THANKS!!! Here is my code: Function calAutoNumber(sheetName As String, StartCol As String, startrow As...

Is there a way to activate either the Add-Ins tab or a custom tab in the ribbon when the workbooks opens? Maybe something like: Private Sub Workbook_Activate() ActivateAddInsTab() End Sub

I have a sub, and to start it i need to press "F9" on my keyboard for example. I want to start this sub of mine, with another sub that allows me start the previous one without pressing "F9". What's the code to activate the "F9" button on my keyboard without pressing it? Thanks a lot!

Norie advised not to select or activate cells but I don't know how to offset from the activecell as in my following code. The script looks for values in column D, if it finds the value it offsets the value from column A to another cell. Sub Process1() Application.Calculation =...

Help! Trying to open a file using vba and then go back to original file that holds the code below. Ultimately trying to do a vlookup using two workbooks but can't get past this point. Getting an object required error and stops at last line of this code: Sub Format() ' ' Format Macro ' Dim...

Hi All, I have a bizarre occurrence! I recently posted a thread here because I had a modeless userform (modeless1) which was activated from a modal userform (modal1) and when used, returned back to modal1 in a loop - the user could then call modeless1 again if more data needs to be processed...

Hi All, I have userforms that 'redesign' themselves - the layout of textboxes and labels, the size of the userform etc - depending on the value in a certain cell. What you see when the userform 'redesigns' itself is flashes of the original size of the userform, or labels in their original...

Hello. In my sheet activate code, I have a series of rows hidden, as shown below. Private Sub Worksheet_Activate() Range("16:364").Select Selection.EntireRow.Hidden = True 'Hides everything when the sheet opens End Sub I have check box controls that if a user clicks in a specific check box...

Hello. I am trying to speed up macros that were written by people before me. I have basically just removing the Copy/Paste code and using Sheets(destination).Range(putithere)=Sheets(source).Range(data).value This works fine for data assignments within a single workbook, but when it comes to...

Hi everyone I have a list box which lists the current workbooks that are open, I want to be able to activate/ goto a workbook based on which row/ value I click on in the list box so that I can them run various other things, can somene help.

I have some code here that is meant to copy data from three different workbooks and consolidate it in one worksheet in a new workbook. Here's a sample of the first part of the code: Sub AutoConsolidateDealStatus2() 'Specify the start row for the New Workbook Dim d d = 2 'Maximum Amount of...

When there is a large number of worksheets in a workbook and you right-click on the arrows to the right of the worksheet tabs, you get a list of the sheets in the workbook. If there are too many to fit in the menu, it gives the option of "More Sheets...". When you click on this you get the...

I've created a spreadsheet in which I have a column of web address links that should take the user to the documentation source. How do I activate the links? Some copied over active, but several did not.

I just need a macro to find and activate the first non-zero cell in the second column (Avg. Px) <TABLE style="WIDTH: 132pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=176 border=0 x:str><COLGROUP><COL style="WIDTH: 36pt; mso-width-source: userset; mso-width-alt: 1755"...

I have a workbook with several userforms. When a user fills out the form, the data in inserted into a series of columns in a single row. The next time they use the form, Excel adds the data to the next available row. Now I want to add the ability for them to edit one of their entries via a...

Hi I get runtime error 1004, Activate method of Range Class failed when I run the macro below using a double click from a sheet called "Europe". I have highlighted the code where the error occurs - any ideas anyone? Private Sub Workbook_SheetBeforedoubleclick(ByVal Tgt As Range, Cancel As...