Forum

Hi Mike, At the begiinning of the PrintSheets procedure, your code is printing visible sheets WITHOUT setting the print area. After printing those,...

The VBA Project is password protected in all files provided, can't help you.

ThisWorkbook.Worksheets(cboAsset.Value & "_Request").Visible = xlSheetVisible if cboAsset.Value="Beach" then ThisWorkbook.Worksheets("Senex...

This code can be replaced: For I = 1 To 20 On Error Resume Next If I = 1 And Sheets("Inspection Sheet (1)").Visible = True Then Worksheets("Inspect...

Interesting challenge, indeed, but not clear unfortunately. Where are those years coming from? (1978, 1984, 1989, 1995) that have the same days o...

You are using a static value, hard typed, not a dynamic value for sheet name: ThisWorkbook.Worksheets("DataEntry").Visible = xlSheetHidden To hi...

I don't understand how the suffix "_Request" goes to the correct sheet name. What about if my sheet names had different titles? Like "Request Form 1" ...

how come I only have to enter "_Request" as the form name that it opens up to ? as opposed to the full sheet name of "Senex_Request" or "Beach_Request...

Hi Mike, You have to clarify the logical chain, previously you was using 2 parameters (Z > 40 Or pa), now you use only "z". In this case, use AN...

Here is an example of summing data with power query. I Grouped data by column 122 as ID, aggregating columns 123 and 125. (have no idea which are t...

Hi Mike, Try to use ElseIf conditions, or select case. In your code, each If line will be tested and that overwrites the previous result, if there ...

What's this code for? Code_Testing_Macro_Enabled.Senex_Request Application.Goto needs a range address, should look exactly as provided: ...

Hi Mike, There is no file attached, please use the button Start Upload, not just Select Files. PrintArea is easy to set, here is an example, you...

If you want to start the code when there is a change in that dropdown, use: sub cboAsset_Change() On Error Resume Next Application.Goto T...

Can you provide a sample csv file as well? The structure of that file is really important in processing, no matter if it will be power query or vba.