Search results

Hows this? Sub LoopThroughCharts() 'Loop through every graph in the active workbook and remove trendlines 'Have to run this twice to remove all trendlines 'First run removes trendlines from one chart 'Second run removes trendlines from all remaining charts 'This code works!!! Deletes...

Manish Have a read of the post at: https://www.excelforum.com/excel-programming-vba-macros/1207695-working-with-paths-over-255-characters-file-count.html

Can you please post a sample file

Try this: Private Sub Worksheet_Activate() Dim wSheet As Worksheet Dim M As Long M = 1 With Me .Columns(1).ClearContents .Cells(1, 1) = "INDEX" .Cells(1, 1).Name = "Index" End With For Each wSheet In Worksheets If wSheet.Name <> Me.Name Then...

Josh Can you please attach a sample file

Assuming this data layout: B9: ="Section" & IF(C9>1,"s","") & " " & TEXTJOIN(" ",TRUE, IF(C3:C6="Yes", RIGHT(B3:B6,1),"")) Ctrl+Shift+Enter C9: =COUNTIF(C3:C6,"Yes") Enjoy

F2: =SUMPRODUCT(($B$5:$B$298="Guest")*($A$5:$A$298>=DATE(2021,1,1))*($A$5:$A$298<=DATE(2021,1,31))) F2: =COUNT(IF($B$5:$B$298="Guest",IF($A$5:$A$298>=DATE(2021,1,1), IF($A$5:$A$298<=DATE(2021,1,31),)))) Ctrl+Shift+Enter

Clear all the cells in Rows 2:6, they should have nothing in them Except for the cells with the Selection Criteria Then it works fine

Some formulas are Array Formulas by default eg: Sumproduct

What unit are you converting to what unit ? Can you please post a sample file?

Look at the expression =AND(EXACT(B9:F9,B9)) if you select the text part of that EXACT(B9:F9,B9) Now Press F9 it displays {TRUE,TRUE,TRUE,TRUE,TRUE} Which is the comparisson of F9 with each cell in the range In this case they are all exact matches and so it displays an array of "True"" The And()...

Left() and Right()are string functions and so return strings as outputs In J4: Put =VALUE(LEFT(B4,3)) You get the idea now ?

Can you please attach the file?

Paul the 2 macros work together with the global variable

My file has code in the Sheet1 module Did you see that ?

Paul Refer the attached file:

Private Sub CommandButton1_Click() TextBox1.Text = "Apples: " End Sub etc

The Data table is in Range AI10:AN30 Refer to the diagram below and the points below for s description o how it works 1. The data table is a Row Lookup Table and uses cells in Row 10 Columns AJ:AN 2. The DT places the looked up values 1 to 5 into cell G12, The Scenario Number 3. The model...

Updated as requested

1. No, But just do it manually, that what I do 2. Yes, I'll repost in a minute 3. Select the Data Table area and Apply a format using Ctrl+1

Gregg I'm going to have to start charging commissions on this work ? ;) Have a look at the attached file Check out the data Table area Enjoy

Select W12:W24 Edit the CF and edit the green (2nd CF) Use a Formula =AND($W12>0, Data!$G$3="") Type that to ensure the " are the correct " 's Set the CF to stop if True

@Daics Can I ask what the application of this is ? If it is for displaying wind roses, there are better solutions already around

C3: 1% C5: 2% C12: =IF(VLOOKUP(B12,$B$2:$C$6,2)="",1-SUM($C$11:C11),VLOOKUP(B12,$B$2:$C$6,2)) Copy C12 down

Your model doesn't really explain what you want to do Please use specific references and maybe give us an example It is also preferable if you don't reference external web sites Thanx