active

Hey everyone, I would like to ask that how can I select all the cells starting from Active Row, Column A up until Active Row, Active Column. For instance I am at cell G12 What I want is to select A12:G12 Similarly If I am at D19 then select A19:D19 Thank you and will appreciate.

This post can be deleted as I figured out the solution, but the option to delete is no longer available. Regards Pete

Hi. Got a question. I got a timer that counts from 1 min down, then runs a Sub called shutdown. The problem is, when it closes, it leaves a open empty excel program open, not completely shutting it down, i fixed this with the code under, but if i got a other workbook active, it asks that to...

Hello I have an Excel sheet with formulas and text in hundreds of cells. Is there a way to click a button and add this sheet to the active workbook for any xls file that I may open? Some formulas refer to a sheet with a specific name, so when this sheet is present in the workbook, the...

Hi, I'm trying to calculate from a dataset a =Percentile.Inc function with a condition. For example, I want the 20th, 40th, 80th percentiles from the dataset for ONLY "Active" status in column B, using the values in column A. My formula for 80th percentile is...

hello! Start a Macro in an active workbook that will open a different specific workbook and copy its specific sheet to the originally active workbook? and then close the different specific workbook?

Hey all, How would I be able to get to a specific column number using vba script? For instance, in cell B2 of sheet name "HSheet" is a numerical value of 8 And I could be on any other sheet other than HSheet of my active workbook. On triggering the code I should be now at my desired column H...

I want to assign a macro to an active x command button. However the code is not in the sheet object, but rather in a module. What do I have to do for the code to run from the module? At the moment when the button is clicked, nothing happens. The reason I don't have the code in the worksheet...

Hi, Does anyone have a VBA code that stops a user from switching between worksheets in my workbook if columns A, B, E, F & G on the active row are not all blank? Thanks Dan

Good morning. I'm looking to calculate how many days an item has been active for on my spreadsheet. I've messed around with formulas and a little bit of VBA, but can't get it to work. There's a formula within row 1:1 that will highlight the cell green, and display the text "Today", based upon...

I have several spreadsheets that require the 'Enable Iterative Calculation' to be selected in order to work correctly. Our business calcs require circular calculations on almost every sheet. Once I have this option checked, it stays active but only for me. It does not stay checked for my...

Hi, Is it possible to Save a copy of an active workbook to a specific folder as a CSV format file while using the dialog pop up? Also I have an issue where If I cancel then the active book name changes to False, can someone help please Here is what I have at the moment which changes the active...

How to Copy Active sheet to new workbook without shapes(buttons) ?

Hi, "If ActiveCell.ListObject.Header Then" I want to do something different if the Active Cell is the Header than if it isn't. I have many tables and the Header Name is different for all of them. Any help appreciated

Hi, I have the below code that opens and copies data from a closed workbook to the active workbook. Sub FetchData() Dim src As Workbook Set src = Workbooks.Open("G:\Managers\Existing Managers\Equities\Data Management\Monthly Manager Research...

Here is what I am currently building: Sub Macro1() Dim ER As Long ER = ThisWorkbook.ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row Dim Cell As Range Dim CriteriaRange As Range Set CriteriaRange = ThisWorkbook.ActiveSheet.Range("A2:A" & ER) For Each Cell...

I have a directory of Excel files which are present in several sub-folders. I also have Information in column A of my Worksheet 1 (which will be the active sheet) and will be an exact match to the folder name. I would like to design a macro which searches all of the folders in a specified...

I'm trying to find code to make a copy of the active sheet and rename the copy using part of the Active sheet name. For example if the Active sheet is named "Expenses" then I want the copy to be named "Expenses - West". Can anyone help?

I’m attempting to display only the Active Members in my database (Sheet11). This code populates ListBox1 with the entire database Range (C2:C). How can I modify the code to show only the Filtered Range? Private Sub CommandButton4_Click() If CommandButton4.Caption = "View Active Roster" Then...

Good morning all! I have a table (T_Staff) with 20 columns (the first 5 are hidden). The 15th column is titled Active and has data validation to allow either Yes or No meaning either the staff is active or is not active. I would like to have a button that when clicked will delete the table...