attempt

Guys, Please can someone have a look at the below code. It essentially looks at 12 different tables and removes anything that is not "1st Attempt Made" in column D. Its doesn't seem to work all the time and sometimes leaves 'New Calls', '2nd attempt made; etc in some of the tables. Sorry if...

Hi Guys, Could someone help me with the below. I have recorded this Macro but i need to adapt it so it filters and deletes all rather than look at specific rows. I essentially want to select 6 worksheets in total, filter by column D and delete anything that does not show 'New Calls' Thanks...

I have a large spreadsheet with dates in text format, YYYYMM. I used the Text to Columns option and selected Date YMD. When i attempt to convert the cell to dates it converts 201801 into the year 2452, July. Any suggestions?

I've created a UDF that returns the values "Good", "Average", "Bad" depending upon the colour of the text format of a cell. I'm trying to use it in an array formula or a sumproduct formula, but I get only a zero or one which seems to have little relationship with the actual colours of the...

Hello - I have a simple Workbook_Open macro (in the ThisWorkbook module) as follows: Private Sub Workbook_Open() ' Ensure that calculations and screen updating are ON Application.Calculation = xlCalculationAutomatic Application.ScreenUpdating = True ' Leave workbook in working state...

Looking for code assistance, please. How do I select cell A1 & dynamic range for ActiveWindow.Zoom = True My attempt (in blue) doesn't work. iCol = wsSheet1.Cells(1, Columns.Count).End(xlToLeft).Column wsSheet1.Range(A1, iCol).Select ActiveWindow.Zoom = True

Hi Everyone I am working on a macro where I need find the column number which contains a particular text. However the noted cell is merged with others. I prefer to not unmerge the cells. Is there a way to make the match function work with merged cells? If match is not the way to go then I...

I'm trying to load some tables into an Excel workbook every morning. Here's one the URLs https://www.fangraphs.com/leaders.aspx?pos=all&stats=bat&lg=all&qual=y&type=1&season=2018&month=13&season1=2018&ind=0&team=0&rost=0&age=0&filter=&players=0 I have Excel for Mac. My understanding is that I...

I am trying to type an IFS statement that will look at one cell and decide on the answer based on a greater or lesser than decision. 10 sq. in. or below = $7.00 10 - 25 sq. in. = $10.00 25 - 50 sq. in. = $14.00 50 - 75 sq. in. = $17.00 75 - 100 sq. in.= $20.00 100 - 150 sq. in.= $23.00 150 -...

Hi I’m trying to write a calculation formula that will do the following: Price £14.99 x 9% + £0.10p minus 10% x 20% Price £14.99 x 2.9% + £0.20p Result = £2.20 My attempt is below: =SUM(D2)*(9%)+(0.1)+(D2)*(9%)*(-10%)+(D2)*(2.9%)+(0.2) (D2) is the Price £14.99 Any help would be great...

Hi all, I am a new member to the forum. Need to know how to use IF and MID function together, in order to return a text value: Examples of scenarios below: 1.Gender: Display M (Male) and F (Female). Extract it from a 13-digit ID number( e.g. 6105245137079). The gender is determined by the...

I was wondering if someone can tell me if Excel has a way to pull a user name from AD using a text box input and an MSGBOX output and if so what the code may be to attempt this? I have attempted it but each time I try to do so I fail and would greatly appreciate if anyone may know the code for...

Hi all, This is my 3rd attempt to try and get an issue fixed with one of my workbooks. These are the errors I'm encountering which happen about 25% of the time I open the workbook: https://imgur.com/a/UHsmy Attempt 1...

Hello everyone, first off, Merry Christmas! Now.. Basically i am trying to make a macro that does many things at once (I am very new to excel and VBA as you will probably tell once you see my code lol. I want the macro to do all of these things in this order: 1) save the current workbook 2)...

Hi. I am new to vba . I try to create userform.but when I attempt to click userform in developer. Excel automatically gets closed.

Hi there. I have an add-in I've been working on. There is a part of it that goes out to the internet and grabs data from a table. Since it is an add-in, if the user has really high security, they will get a security warning popup every time they open any workbook. What I'd like to do is NOT...

How many of you keep a cheat sheet with your most used and most useful formulas/macros on it? Just curious. I've been thinking of starting one instead of trying to remember them, and remembering them wrong most of the time. That really makes me look good..."Hey, can you help me do such and...

I have attempted to use the sum/frequency/if formula combinations and have failed (although it could've been user error as I don't frequently use those together). My data is as follows: A/ B/ C 786698/ Attempt 1/ Plan A 786698/ Attempt 2/ Plan...