active

Hi, I would like some input/pointers on how to solve this, I'm not sure where to begin... I want to write Active, Not active or Ignore in column E based on three criteria. As you can see in the table, a person can occur 2-3 times, even 6 times in my orginal data. Data is sorted on column A. If...

Hi I selected cells A1:A20. They are all selected and the active one now is A1. I can make A2 as an active one without losing the selection by pressing Tab key, I can make cell A10 as an active one by pressing tab key as well. My question, if A10 was the active one. How can I go back to cell A1...

Hey all new here. I am having an issue changing code to place textbox value to current active sheet rather than a specific sheet. I am working my way through to create an active form to generate data based on scanning an item into a single textbox. TextBox1.Font.Size = 28...

I have macro that runs from an 'activecell' that copies the active row, macro included into the row right below it. Its a simple insert new row macro. Now my problem is i only need 16 continuous rows. After 16 rows i need a different event to trigger. But i can't figure out how to count 16...

I have a file with more than 600 sheets and I am using a macro to change the active printer : application.ActivePrinter="\\xxx on Ne01:". This single line of code may take up to 90 seconds to execute. Changing the active printer manually takes a second or two. Is there a way to speed up the...

S1 is my macro template. S2 is the actual report which gets a new tab each month. Ex. T1-Jan T2-Feb- etc- to current month. Sometimes there are changes to S2. So, I want a system to cross check if anything has changed. Exaple. S1 n S2 look identical unless a new loan type was added. So - I...

I'm looking for a simple piece of code. I have a button that opens a prompt for me to select a file, I need to just copy cells B2 and B3 from that file and paste them in the active worksheet. That's it! Quickest way to do that?

Hello, I have a large data set in tab 1 and in column T there are statuses (Active or Retired). what I would like to do is create a new tab (tab 2) to only show those individuals with an Active status. So every time I change the status to Active in my first tab it would populate into my new tab...

Morning all, I have a .CSV with contact information and in column E is the email address. The source of the emails (another Workbook) shows them as a none active link - i.e. if you click the email, or hold Alt and click nothing happens. So when these are copied over they are still a none active...

So I entered the code below into my personal.xls thisworkbook section in hopes that every time a new workbook opens i would get me the name of the new workbook displayed. But no, the first time it gives me "Personal.xls" subsequent newly opened work book it does not respond at all. Any ideas...

Hi all, Below is the code to create a new workbook with the active worksheet of an open workbook Sub sb_Copy_Save_ActiveSheet_As_Workbook() Set wb = Workbooks.Add ThisWorkbook.Activate ActiveSheet.Copy Before:=wb.Sheets(1) wb.Activate wb.SaveAs...

Hello, I have a large process that I am attempting to break down into smaller steps. workbook 1 call Master workbook 2 call Table From the Master I want to open Table, make that workbook active, eventually populate with data from Master, and do a save as local. These files are on a ShareNow...

Hello! I have the following code below and it works great but I need to add to it if possible! I am running a macro in sheet1 on active cell column C and matching it to sheet2 column B cell that works fine. But what I need now is when the match is found on sheet2 column B I need to copy the row...

I am using the following code to create a duplicate of an active file and then close the active file. But I am struggling to open the file I just created. Will appreciate some hand holding. Sub Copy() Dim strFilename As String strFilename = ActiveWorkbook.Path & "" & "GJCT Roster Week " &...

Hello I need to save as copy the active workbook with all macro and all subroutines in tab (this workbook) as xlsm file I do it but the macro create new blank file with all my macro Did have solution on my problem Wait your reply If you need my file will attached it soon

Is it possible to increase the height of a active x control text box as you type in it. This would mean that it appears to expand downwards. I tried the auto size feature but this just shrunk the text to squeeze it all in when you deselect the text box.Is it possible to make it just stay...

Hi all, I've found a VBA script to duplicate the current active worksheet, but I need to copy a different worksheet in the workbook X amount of times (X = number in a cell). e.g. Active Worksheet Name: Start Worksheet to be copied: Master Copied X times where X = Start!A10 Names of...

Cant figure out why i am unable to get the correct response if 3 conditions state Active then give me Active ,if they all do not give me Inactive I am building this report from Excel to Access I am trying to duplicate this code in Excel...

I have three columns. Only one cell in column A will have a value, which will be "Active". Column B is locations. In column C I'm trying to get anything that at or below the "Active" indicator to populate as "Down" and anything above the "Active" marker to populate as "Up". <tbody> Minn Up...

This was recorded Sheets("Sheet1").Select Cells.Select Selection.Clear Range("A1").Select With ActiveWindow .SplitColumn = 0 .SplitRow = 1 End With ActiveWindow.FreezePanes = True Columns("A:A").ColumnWidth = 36 Columns("B:B").ColumnWidth = 36 Is...