I have looked at a lot of different ways to do this and tried to incorporate their ideas into this sub but I keep getting different errors every time I run it. I am searching for "0" in the listed ranges of the STATUS SHEET and finding the offset value which is the vehicle number. then finding...
Hello all,
I have made the following VBA codes to save specific sheets of a workbook to a new workbook. However when I hide the sheets it no longer works. I want to keep those sheets hidden in the current workbook but not in the new workbook.
Here is the code:
Sub Export()
Dim DCname As...
Hi VBA Developers,
Hope you are fine,
Please note I have been trying to create a database but in this case, I only need a column with the data, based on some parameters but during the process I am confused since the code I think should have some loops.
Probably my code is a mess, but...
Hi all, I want to use the autofilter for partial match in two columns, it not works for two columns but works for one column.
May I know how to revise the code?
Sub Search()
Dim Mws As Worksheet
Dim PR As Worksheet
Dim Rng As Range
Set Mws = ThisWorkbook.Sheets("Data input v2")
Set PR =...
Hi -
I have an excel table with 6 Columns (fixed) and then I want to be able to fill in as much content in the rows without limitation.
Problem:
I want the table contents to fill into the charts and automatically and automate adjust, so that it’s easy to read with the same excel sheet if...
Dear All,
I have a workbook with many sheets with multiple slicers in each sheet.
I am looking for a vba code that is assigned to a button, on clicking it it should hide all the slicers and again clicking it it should unhide.
The button text should change based on slicers current status...
Hello! Is it possible to have a formula or code that allows for selecting multiple selections from a drop down list that can appear in one cell? Potentially separated by commas? I've seen some folks talk about a VBA code, or a potential list box, but I am not sure where to begin. Attached is my...
Good morning,
I searched the web for an answer, tested few but without success. Please move this to the correct forum if needed.
I have a PowerPoint with several slides, each with one or more pictures linked to saved png files.
They were added using this path:
Insert Tab / Pictures / This...
Hi everyone,
I'm an excel newbie and trying to figure out how to make something work in VBA. Y'all seem like a really nice bunch, so I'm hoping you can help me out!
I've managed to automatically create a pivot table containing days worked per week per person from a raw data file and would like...
Dear all, I am a new user of Excel VBA and try to use it to automize the daily working routine. Now I'm facing the problem of checking duplication and change the value.
So basically what I would like to do is to check the order for customers and I would like to check whether there are...
Hello!
I have a workbook that lists products we sell, for who, when and how many we have sold of each product. I would like to add macro into workbook, which based on multiple criterias can figurate the exact matching and return the requested relevant information, what I need.
To simplify my...
Hi there,
I have a VBA that works perfectly fine for its current use, however I need it to be more specific about where it pastes the data.
I really need a code that takes the value in a selected cell, copies it to the next empty cell in the column between rows 4-8, adds cell colour fill...
Hi all,
I'm copying some data over from an input spreadsheet into a data table, I'm using the below code which finds the first blank cell in the tables first column and correctly updates the value, but then when I repeat it moves down a row, I assume because the table auto creates the whole...
Hello All I created this code. evrithing seems fine but ALL THE TIME error 5
Sub Exportar_Imagenes()
Dim img As Shape, tempChart As ChartObject
Dim sPath As String, sName As String
Dim imgEncontrada As Boolean
' Ruta donde se guardarán las imágenes
sPath =...
Hi! i´ve been struggling with this one for a bit now. I want to paste something into the Last Column Header of a Table. I´ve tried with following code:
ActiveSheet.ListObjects("TableName").HeaderRowRange(LastColumn).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone...
I'm not really sure what you'd call what I'm trying to do, but here's my best attempt to describe it.
I'm creating a summary sheet that will pull from an unknown number of sheets. I've employed Indirect to assist me as I hate #REF errors should referenced sheets get deleted. I have my macro...
Hi out there,
my project is about creating userforms based on the values in a worksheet. People planning their USFs in advance or work with templates can accelerate the setup in a smart way. The code to create this both items is:
' the objects are declared as VBComponent
Set mdl =...
Hi all,
Silly question but this is so unintuitive for me:
For Each Table in Doc.tables
For Cnt=1 to Table.Rows.Count
Row = Table.Rows(Cnt)
If ...
DataRow = Table.Rows(Cnt+1)
MsgBox DataRow.Cells(2)
End If
Next Cnt
Next Table
I can do...
dear all,
I'm currently stuck with Excel and I hope you guys can help me.
I am looking to lock specific rows (in the screenshot: the forecast quantity) D6-O6, D9-O9, D12-O12, D15-O15, etc (until D24-O24) after a specific date has passed.
This date will be defined in D3-O6.
So the way it...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.