bit

How do I convert this to work on 64 bit machines (as well as continuing on 32 bit as it is now...). Thanks Option Explicit Enum W32_Window_State Show_Normal = 1 Show_Minimized = 2 Show_Maximized = 3 Show_Min_No_Active = 7 Show_Default = 10 End Enum Private Declare...

=INDEX($C$1:$C$16700,MATCH(1,INDEX(($B$1:$B$16700="A")*($B$1:$B$116700="B"),0),0)) On my spreadsheet, I had two columns, one for work shift, and one for what printing press was used. Now both columns are filled with these formulas. I don't recall writing them. I'm a little bit confused as...

Good afternoon - since our upgrade to Win 10/Office 2016 64 bit, a lot of my functions, including those to extract IP addresses from HostNames and vice versa no longer work (no surprise there, then) Even when I add PtrSafe to my existing functions that worked in Win7/Office 2010 32 bit, the...

I have been out of the loop of using Excel for a while and I've been asked to look at some vlookup formulas. VLOOKUP([@Name],Table2,2,0),"" What is going on with the [@Name] bit? Name is the column name in the table that this formula is in. I understand that bit. If I over type Name in the...

I know this isn't the normal type of question for this forum, but I wasn't sure where else to ask. Recently I had an issue where research indicated I'd benefit from changing to the 64 bit version of Office 365, so I did. Now, however, I'm running into things I've not seen before. One example...

Hi All, I have a drop down with a specific month, my forula does the trick and displays all dates for that month, but how can I display WORKDAY's only? I am a bit stuck, your help is appreciated. A1 = Dropdown date: =IF(A1="","",DATEVALUE("1 "&A1)) The in next cell this formula...

Hi from York UK... This formula: =MID([@URL],SEARCH("/",[@URL],8),SEARCH("-t*.html",[@URL])-SEARCH("/",[@URL],8)) does exactly what i want but i just copied it off the internet. The results of the formula are below...

Hi All, Thanks for putting in time for viewing my post. I am stuck with a runtime issue, the bit of code that seems to be causing an issue is the text below in bold "DoCmd.SetWarnings True strFile = arwGetPersonalFolder & "\BromptonLungFunction.xls" ' &...

https://goingconcern.com/this-guy-is-why-accountants-on-twitch-totally-needs-to-be-a-thing/

I understand this will seem like a strange query, I guess it may just be a little OCD kicking in, I get annoyed when I've ran some code on a worksheet and various cells are highlighted when I select the sheet for viewing. Is it possible to deselect all cells in a worksheet, or select...

Good Day Could anyone please help with me with a simple bit of code required to add the details of a userform to the bottom of a list The userform looks like this --> https://drive.google.com/file/d/1q762SqtZkq6knLa9uChjxCy-9PxuUcop/view?usp=sharing The List is located in Column KD. The...

Hello! I have data in three columns: A,B,C and each columns has several rows with numbers. I want to return all the A numbers that match: B= 4 or 3 AND C = 5 Any idea? I have been browsing through several websites but most at horrible in explaining bit by bit the formulas. Thanks!

Hello...I have downloaded VBHTML Maker so I can post code so it's easier to read, but I just saw that it does NOT work with Excel 64 bit (which I have on my machine). Is there another way I can easily post code to the forum without doing a straight copy/paste, thus making it hard to read...

Hi, i'd like to ask, since this is bit confusing, i don't know how to rank like this case. my goal is to keep the rank in order, not skip it even if there's duplicate. thanks a lot for your help

Hi I'm after a bit of help please... I'm compiling football stats for my team, and I'm a bit stuck! I have my sheet laid out similar to the table below. In the overall appears column, I'm trying to add up the 3 apps columns using a formula to return what I've typed in the Target column. Can...

Good afternoon, I have an old code running under 32 bit. But now my computer was updated to 64 bit. When running the following code, I got a message to ask to update the code to 64 bit and mark them with PtrSafe attribute. How can I change it? Sincerely. DL [/'Private Declare Function...

I have a WS with 3 column 24 row that is fully populated with formulas that are dependant on data from other WS However this sheet's results are variable and only result if they are not in Error This leaves several rows down to 24 that APPEAR to be blank but STILL have a formula in them This...

Hi All, We have just uninstall office 365 for 32 bit and reinstall into 64 bit for quicker processing but now every time when we open and close the excel we get the below error message: "Compile error in hidden module: HsTBarPublic. This error commonly occurs when code is incompatible with the...

Hi I have looked through the old posts on this and I a not clear that this is checking for Excel I want to perform actions based on 32bit or 64bit version of Excel not machine capability I have 2 users both using 32bit Excel but 1 has 32bit operating system and the other 64bit. #If Win64...

So basically, I click on a button, some things pop up, and it names my sheets for me. However, I'm having a bit of a hard time trying to get it check to see if there's already a duplicate sheet name. Right now, it works perfectly, until I create two worksheets with the same name. Would anyone...