active

Hi I want to add a sheet but I want to keep sheet1 as an active one. I named sheet1 as "Hello". Now when I run the code below, it will do these 2 things 1) Adding a sheet before sheet1! why is that? In excel when I click + to add a sheet, it will add it after the active one not before like what...

Afternoon all, I'm looking for a bit of help on the following. I've had a search through the forums but haven't been able to find what I'm after so I'm maybe looking for the wrong thing altogether. I would like to create some sort of custom calendar, using only formula from a list of data...

I have one of these on my worksheet but there is no code anywhere that would have AddItem'd it. I must have done it but I can't remember how. Tried adding another one as a test but I can't see where items would be added to it. What as I missing ?

Good Evening, I have a formula here that calculates the time difference from one date to another. It should spit this back in whole hours and it does. However, if I go over 23 hours (i.e. noon to noon), it goes back to zero because I think it's taking out a day. I need it to be able to hit 24+...

Hi I’ve got a vlookup in one sheet that looks up data from another sheet. However, there are a number of instances where there is no matching data, so the formula has been written to return a blank instead of an error. But I’d like to to create a formula which returns the value of the cell...

A1 = 2 B2 = 5 C3 = 7 C3 is the sum of A1:B2. If I were to delete the values in A1 and/or B2 what formula is needed to "keep" or retain C3 as 7. Last calculated value to remain active. Thanks

I am trying to search for the first cell above my active cell (just in the same column) that contains the words BOX or SPARE. The words BOX and SPARE will also be followed by an integer value that's up to 3 digits long (e.g., SPARE 22 or BOX 81). I'm trying to find the first cell that contains...

I'm trying to make a macro that uses two workbooks, one just being the active book and the other being named "ASIN to LD.xlsx", which would be opened and hidden by XLSTART. It uses two key columns in the other workbook (ASIN to LD). The two columns are columns A and B and A1 has "ASIN" in it...

Hi, i'm trying to write simple script to check webpage status. And i have a problem with feeding url address from active cell. Public Function GetServerResponse(url As String) As Integer On Error Resume Next With CreateObject("WinHttp.WinHttpRequest.5.1") .Open "GET", url...

Hi all! In a worksheet where there are several pages active in Page Break View, is it possible to deactivate any of them even though there is information on them? Thank you! Russ

Is it possible to apply a fade from one colour to another on an active x command button?

Hi Everyone, I run the following code to UNHIDE a sheet(LOTTERY RECEIVED) from a button on a different sheet(LOTTERY). It works fine except I would like the sheet(LOTTERY RECEIVED) to be the active sheet in the workbook. Not quite sure how to get there? Thank You!! Sub...

Hi, I have the below table, what I need is to sort the numbering by ascending order, it's easy if I have a fixed table, but the challenge is this table is dynamic, it changes whenever I change the EE ID. Can you help me with the formula that solve this issue? <tbody> EE ID AAAA...

I have 20 workers , each with a barcode.I need the active block to be A1 on a specific sheet . So if Paul scans his barcode i need the active block to go to his sheet, and if john scans his barcode i need the active block to go to John s sheet A1 ? Can it be done ? Thank you.

so i currently have two sheets on a spreadsheet. one called active months, the other called payroll. in the active months sheet i have 3 columns. one for each month of a quarter. so for example i currently have in there jan, feb and mar. i then have a list of employers with their start/end...

Hi, erveryone.. I am creating a project with MS Word VBA consisting of an active document and a userform. I want the ducument and userform to stand aside from each other. The problem is, If I set the modal userform property = true, then the document cannot be edited. And if the modal property...

Hey Excel Gurus, I would like to know the formula for highlighting the active cell of my worksheet using Excel's built in Conditional Formatting rules. Will appreciate and thank you.

Hi, I've some active X controls which have taken on odd behaviour. They are label and combo box controls. As I mouse over them the cursor becomes a 4 pointed thing whether I go to design mode, or not. There's no dropdown action. A right click shows a different menu to the expected one starting...

Hey, The following code from one of the recent posts perform the task of selecting the cells starting from column A up until actively selected column. These will select all cells in between. However I would like it to select column A and active column only, hence leaving the adjacent cells in...

Does Excel have the option of freezing various cells, not just rows and columns? This way, as you move around the worksheet (cursor, tab, etc.) the active cell would always be in an unlocked location.