vba

Hello brilliant people, I am working on a set of utility macros and this one little thing is nagging me. (Ok, lets be honest, theres a ton of things, but this is the one I need help with) I have VBA adding a table, and then adding a formula referencing an entire column of that table. Set tbl =...

I'm very new to VBA, so this is likely a simple question to answer, but I couldn't find it while googling. I have a Sub that is working fine when I use ThisWorkbook.Activate but refuses to run if I replace it with a direct reference to the workbook, and I can't figure out why. Version info...

Question says it all. I cannot figure out how to automatically populate the print area / print tile section by referencing 2 dates. I’m using pay period dates. Start date is in cell A2 and end date is in cell B2. I need a formula to find these exact dates within column A, then return the...

Hello, Please note I am working a macro to create folders with a specific path address If I leave the path address in Visual Basic backend as below it works, but for some reason when I assigned a cell or range("D28").value Visual basic app detects there is a "?" in the path address as...

Hello I have a list box inside a user form and I want to display the total amount in the list box in a text box or label For this I used the following code Private Sub sum_subjects() Dim total_v As Double For i = 0 To ListBox1.ListCount - 1 total_v = total_v + Val(ListBox1.Column(5...

Hi all, I regularly download CSVs of delegate info for events. However, they include a lot more rows than I need. To get around that I usually convert it to a table as I often need that later, then hide the rows containing "Attending" in "Column1", then delete the remaining rows, then show the...

Hi, I'm having trouble doing the VBA to create my own function. I have the excel formula to do it, but I just want to be able to have it be a function so that I can do something like =FirstWord(A2) The excel formula that does this is: =IF(ISERR(FIND(" ",A2)),A2, LEFT(A2, FIND(" ",A2)-1)) So I...

Hi, I am trying to set up a spreadsheet to monitor our small vehicle fleet. I have a spreadsheet which we record when the Tax, MOT, Service and Fuel Cards are due, I have conditional formatting set up to change the cells format depending on when they are due. I would now like to update /...

Hello Mr Excel, Its been a while for me, however, I have recently started a new job that calls on my excel skills again and so here I am, looking for some guidance :) I am trying to create some code that copies a range of cells, if a certain cell is populated with a number I then want to open...

Hey everyone, Formulas have taken me so far but now feel like i need VBA to help me out. With the table below I have data in column H and along side there may be data in Column I. I wish to have a new row created if there is data in Column I and then the value inserted into the column H space...

Hello! I've tried everything here and I hope you folks can help me. I have a spreadsheet with several tabs. On each tab, I've defined a named range for the tab. For example, on my Sales Sheet tab, I have the named range called SALES_SHEET. I also have Additional Pages-1 through -8...

Hello, I've been trying to learn VBA to help automate some things at work, but i'm finding the layering of multiple variables difficult. I know how to move 1 line at a time from one tab to another but my current dilemma is how to look at the entire worksheet and move each row to different...

I am doing a Find/replace which replaces all text in quotation marks within the range ReplacementRange with a string of text called ReplacementText which is created by some separate code . My current code is: Range("ReplacementRange").Replace What:="""*""", Replacement:="""" & ReplacementText...

Hello The below code moves rows of data to an archive sheet when they become 6 months old (as of the current date). Could someone help me change it so it moves the data as values, rather than formulas? Private Sub Workbook_Open() Application.ScreenUpdating = False 'Set...

I have been working on this for two days and cannot get the formatting details to come through on the pdf being attached to an email. All of the data is there but it is useless without the formatting Option Explicit Sub CreateAndEmailPDF() Dim wsSource As Worksheet, wsTemp As Worksheet...

So I have got the calendar set up that I can change the months successfully to the end of the year and will populate the different employees in the work centers, I'm thinking I'll have to do VBA again to hide calendars for different work centers to be able to track everything correctly? Any help...

Good Afternoon, I am trying to create a drop down that will allow multiple selections. I have found that I need to use VBA. You can see what I have written, but I think this is for the list of itmes being on the same page. I have one sheet with the lists for the drop down and another sheet...

Hi expert, I have a data table with 3 columns. Column 1: Type of product(Part or Unit). Column 2: Location . Column 3: Block. as image below: Column 1: Defind name: Part /Unit Column 2: Location to located part/unit in sheets Column 3: The block column will show which items are assembled...

Hello, im pretty new to excel vba and i couldnt find any code to make it work to hide cells that are equal to "text in cell list" and < than date today This is the current VBA Code: (Highlighted is the non working part)...

Hi all, I want to attach multiple worksheets in one email but it has the duplicate attachment problem as attached image Would anyone can help? Thank you very much Below is my code: Sub Create_Site_Cable_Usage_AT() Set wSheetStart = ThisWorkbook.Sheets("In out record_AT") Dim LastRow As...