working

The ToggleButton not working after I hided/unhided the rows. Anyone can help me to fix this issue? many thanks!

Hi, I am currently creating a financial worksheet to use for my clients. I already set the size to A4 so everytime I print it, it will be exactly in an A4 size paper. Now, here is my question can I expand the cells where I am currently working? and then when I have it printed it will still fit...

Hi I'm working on macro that allow me to copy last cell in column A to all empty rows after that cell in column A until last used raw in column C. I have tried few but non of them are working. I have userform that fills the sheet with data but one listbox is multiple selection and in column C...

Hi I need a little help please I have put some code together to delete an entire row if a cell in a list starting from B4 and is a variable length. The code is sort of working but once it gets to a point where there are two or more blank cells in the list it is leaving some blank cells. I know I...

Hi, Using the following function among others for my searchable drop down lists: =IF(ISNUMBER(SEARCH(INDIRECT(CELL("address";Forecast!$F$5:$F$1048576));'Master data'!C2));MAX($D$1:D1)+1;0) For some reason it stopped working. I have no previous versions. 'Forecast'!$F$5:$F$1048576 I can see...

Is there no way to create a timestamp in excel with out using a macro? I really need a timestamp but I have tried using a macro and it just isnt working its more headache than its worth.

Hello all, I am having an issue with conditional formatting not updating in my cells. It was working this morning and at some point stopped. However, if I save the file, close it, then reopen it, updates show up just fine. But, if I do that and start working in it again, the cells don't update...

Hello Excel Gurus, I have put the Formula to compare the cell based on the cell value using a threshold of ± 30%, in some cell Formula is working fine but in some it is not at all, I cannot figure this out need help. Here is the Formula I am using; Formula...

Hello We have a very popular game we play at our workplace called bubble shooter. However after the company has updated to windows 10 and excel 365 the game no longer works. When I run the compatibility checker it says "Uninitiated activex controls can not be transferred to the selected file...

Hi I am looking for a VBA to open a workbook (FX rate log) from a specific file path and the look for a specific date (Today()-1) and copy the rows including the date and various currency rates to another workbook (Working model) within worksheet (FX Rate). Data layout in FX Rate log –...

Hi I am building a form for data entry into Excel and I have all other form boxes working but cannot seem to get the vlookup of a response to a combobox to trigger an entry in a text box further down the form I am not sure how to debug it to see which bit is failing as I get no response to the...

I copied this code from Excel VBA: by Nein Smith and I can't get it to work. The data is a mixed list of number from 1-10 in Column A, color line works but the text line does not I know there should be a Then in this macro to the author was just trying to show how Conditional logic works, at a...

Good Afternoon, I have the working code in use as supplied below. When i press my transfer button cell values are coppied from one worksheet to the next sheet. I then manually select from a drop down bow in cell B1 the month & in cell B2 the year. I would like to add the above to the working...

Hi all, I have a column with text that I need to extract into another column. I'm using an IFS(Search) formula to do this which is working for some of the text in my first logical test but not the second even though the text is present. formula =IFS(SEARCH("GrainPro",M92),"GrainPro...

Hi All, Good day! How do I automatically let the macro run when the excel file is opened? Is it possible? I want the macro to start working when I open the file rather than use a button to run it. Thank you Bryan

Hi there, I have the following code that is supposed to insert a blank row at every change change in column 5, but for some reason it is not working. Its a relatively simple code so I dont know what the problem can be. It seems to be working properly on some worksheets but not others, but not...

Good Morning, I have followed step by step the above tutorial but am getting an error. The code that I typed is the following: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo = Target.SubAddress WhereBang = InStr(1, LinkTo, "!") If WhereBang > 0 Then...

I have this formula =IF(H5="x",G5) Which works perfectly. I need it modified so if H5 doesn’t =x, the cell is left blank. I have tried =IFERROR((H5="x",G5),””)and =IFERROR(H6="x",G6,””) but neither are working. What obvious thing am I missing? Thanks in advance

This is something I thought I knew how to do, but it isn't working. I have a column in my spreadsheet with names in the Lname,Fname cormat (Example: Smith,John A) Say this data appears in cell A2. I thought the way to get is was <=RIGHT(A2,(FIND("",A2,1)-1))&" "&LEFT(A2,(FIND(",",A2,1)-1)) >...

This may be a silly question, but does anyone know what the effect will be if I'm actively using other instances of Excel while the queries in another workbook are refreshing? I've been working on linking a spreadsheet to a PowerPoint library. It pulls data from dozens (eventually hundreds) of...