tia

I would like to replace 45 icons looping n = 1 to 45 using Worksheets("Print Label").Shapes.Range(Array("Icon " & n)) with another picture Worksheets("Print Label").Shapes.Range(Array("Choice")) I tried using the macro recorder to copy the selected shape and then right-click on the shape to be...

In A Double-Click Event Macro I'm Having Syntax issues in getting the 2nd code line to "take" Lr = Range("C" & Rows.Count).End(xlUp).Row If Not Intersect(Target, Range("N & Target.Row & ":P" & LR)) Is Nothing Then What's the proper syntax? TIA, Jim

I know I did this before. But can't find where. It was VBA code that inserted the current time (24hr) when the user entered a "t" in a cell. TIA Bob

Hi all, I need a formula to Validation "B9" cell: i.e. if into B8 there is number "1" or "2" then into B9 I can not put anything but if B8 is 3 or 4 or 5 or 6 then into B9 I can put in only 1 or 2 Tia. Maurizio

I have 12 tabs - Jan - Dec On each tab starting cell B6 downwards (with gaps) there will be a customer reference eg AA123456 On a summary tab I want a macro that will pull all of the references from the 12 tabs, and create a unique list. So I can then Vlookup to all 12 tabs. How can I do...

An easy one for the forum I'm sure: I have a list of these: <tbody> Wed Aug 01 11:13:36 2018 I would like to take the date only and have them in a separate column like this 01/08/2018 All help welcomed, tia </tbody>

I have inherited a spreadsheet with a formula I cannot quite figure out. =ROUND(TREND(F3:H3,$F$1:$H$1,4,1),-1) I understand everything except the 1 that follows the 4. What is that 1 mean? TIA

Hey all, I'm trying to use this to increment a number if certain cells equal other cells and then if the range F13:T21 <> the criteria, reset to "0". Am I on the right track? I know it's not working the way it is now. TIA =MOD(COUNTA(F13:T21,N2:Q2,+COUNTIFS(F13:T21,I2:K2))

I am struggling to get the following formula to work when adding a column in the PQE = if ([Theoretical Next Visit] = "" or [Theoretical Next Visit] < DateTime.LocalNow) and ([Next Visit] <> "" or [Next Visit] >= DateTime.LocalNow) then 1 else 0 Could somebody point out where this isn't...

I seem to be unable to use the spaces in the contents of a textbox I have in a userform. Is there some way of allowing this as I can;t seem to find a solution. TIA

I need a formula to tell me if in a cell; - characters 7-8 are alpha - AND characters 9-12 are numeric How can I do this? TIA

I am looking to distribute an amount over several employees as a bonus. I have a different percentage I would like to give each employee. How would I go about this? For example, I want to distribute $1,000 over 5 employees. TIA!

I was hoping the below would set row height on opening the file, but it doesn't work. Why would this be?? TIA Private Sub Workbook_Open() Sheets("Bedstat").Range([A6], [A65536].End(xlUp)).EntireRow.RowHeight = 13.5 End Sub

Hi - I have a table of a few hundred rows and multiple columns (need to check 5), I need to check it against another one. Is there a macro I could use to check each row against each column for differences? TIA

Apologies for the title typos :-/ The code is supposed to look at column K, and for each blank cell, the contents of columns B:J should be blanked out. I'm not great with VBA and have pieced this together from other code so I'm sure its something stupid.............. TIA Sub ClearRows()...

I am trying to figure out the code for the Button (Save to Pdf) when activated will use the name from the TextBox1 as filename and save it to PDF, Can anyone help? TIA....... https://drive.google.com/file/d/1S0X9Ty9LIy4Slacuj5Fr_We-62Mv-FlZ/view?usp=sharing

Hi all, From another forum I have spotted a line of code With CreateObject("VBScript.RegExp") Now I was led to believe that if you create an object, you should set it to Nothing at the end of the routine.? However that was always after something like Set objVBSR =...

My formula is =SUMIF(B6:B93,A101,L6:L93) the condition im looking for is if B6:B93 =B101 then add the numbers from L6:L93 together but when i do its giving me 0 instead of 1 i surely cant be too far wrong TIA

Hi all, Need your help, I have two columns, column A has A B C O E W G H whereas column B has A B C E G H J L P I want Unique alphabats from column B only, means as you can see O and W are also unique in column A but I want to extract J, L and P only. TIA

Hi I have multiple shapes with name/job role on worksheet 1; can I 'link' the shape to their corresponding row on worksheet 2 to generate a mouseover with all their contact details? TIA