true

Hello! I have the following Macro (below) in a spreadsheet I use to record work times for my employees. In column C there is a dropdown in which they are supposed to choose "ARRIVED," and then a timestamp appears in both column D and P. Similar for column E - they're supposed to select...

I have an Excel table with a field called TradingDay that simply stores Boolean values of whether a given date is a trading day. I used the formula described here to get whether the date is a trading day or not: https://exceljet.net/formula/date-is-workday Now I want to create a new field...

I need help with a formula or possibly another way to figuring out this problem: I want to count everything in 'WO Report'!$Y:$Y that states: TRUE Only IF 'WO Report'!B:B Matches List!B2 However only if there is no match between 'WO Report'!B:B and List!B2 I want to count everything in...

Private Sub Command43_Click() 'Admin Button Bring back nav and other views that are hidden If Text9.Value = "tam.badal" Then 'UnHide the hidden objects in the navigation pane Application.SetOption "Show Hidden Objects", True 'UnLock navigation pane...

Hello everybody. I've a cell assuming different values. For example: 105,32 euro Now, with regex I've removed the non numeric value in order to have 105,32 My code: Dim replacement As Object, trunc As String Set replacement = CreateObject("vbscript.regexp")...

Hi. :) The date the Monthview brings back onto my sheet is not recognised as a date. So when I try to look up the date to name the tab it isn't recognised. I have tried the following Selection.NumberFormat = "DD/MM/YYYY" And Application.SendKeys "{F2}", True Application.SendKeys...

I have a sheet where I have a checkbox that is entering TRUE or FALSE into a cell. For some reason I can't seem to get those values to control the conditional formatting for that row based on those text inputs. I have a rule already setup when that cell contains "n". Is there a way I can...

Is there a way to add only a range of cells instead of entire row? Here, I will like to insert from Col B to Col O. I have other data adjacent the range B:O and the entire row is interfering with the layout. I will be more than happy to find a work around. Thanks in advance...

Hi, I have a workbook which collects data from 80 other workbooks. My macro is taking a painful 30 minutes to open, copy, paste and close all of those 80 workbooks. I'm using workbooks.open(filename, True, True). I've concluded that what takes time is opening the files, so I'm looking for a...

Hi, Currently I've the below code which i used to send an email from Excel, However, Now I've moved the code from 2010 to 2016 and its is not working for .Publish (True). Please help With TempWB.PublishObjects.Add( _ SourceType:=xlSourceRange, _ Filename:=TempFile, _...

The code below -- created w/ help from this forum -- does a great job of cycling through a list of ~300 URLs (listed starting in cell A2 of sheet "URLs") and importing the table data from each into sheet "MXquote", pasting each chunk of table data on the first available row, such that the end...

Is there a way to keep the navigation pane closed or keep users from accessing it without proper permissions?

I need to write an if statement based on some conditions which MUST be true and then other conditions of which any "4" (the value 4 needs to be an input by the user) can be true. However, I need the user to be able to determine which conditions are "MUST" conditions. I will have the user...

Hi, I have a time series data set and I am trying to perform calculations based on different flags/conditions. However, I need the macro user to be able to input a "lookback" period which will cause the if statement used to determine that flag/condition to check if the condition was true at...

Need to macro to convert selected tabs to PDF Say in A1 to A10 is the tab name and the in B1 to B10 is true or false If it is true in B1 to b10 then it will convert them to PDF

I would like to open two windows folders on the screen and have them appear side by side on the monitor. I have the code below to open both folders and that part works fine. I just need to know how to size them and move one to the left side of the screen and one to the right side of the screen...

Hello colleauges, I came across a problem to be honest last time I used VBA was 3 years ago, so today I'm preparing a live sheet which shift cells dependant on cell value (product number). I tried to tweak around the code but it seems it just getting commands just from last lines of code for...

Hi, I want to loop through rows in my worksheet and compare the cell values in particular columns with other rows defining a variable as True or False (my segment_trigger variable below) if the values are the same or different. I have written the following code but its giving me "Compile...

This code works fine, but as I need to adjust my sheet rows and which ones should be visible and/or hidden, I would like to put a number in column A to represent the grouping. Private Sub Worksheet_Change(ByVal Target As Range) Me.Cells.EntireRow.Hidden = False If Not Intersect(Target...

Good morning. I am working on the same spreadsheet described in this thread (https://www.mrexcel.com/forum/excel-questions/1112241-hiding-rows-using-vba-multiple-criteria.html) It is a sheet where based on the answers provided in a set of dropdown boxes, certain rows need to be hidden...