vba & excel 2013

  1. T

    VBA code to loop and extract data

    I have another sheet were a user selects a name. Is it possible to have a macro loop through the data and return the event type listed below the employee along with the date. This is just a snippet of the data. An employee will have multiple event types. I'm not sure if this is even possible...
  2. A

    New VBA codes prevent old ones from working?

    Hi everyone, I have an Excel file that tracks engine status from Sales and Production departments. Here is a summary of my columns: Columns A - M in the workbook contain data necessary to deem the engine status Columns N - AS are used to track engine status with the following column order...
  3. mehidy1437

    Export each row as separate image of a selected range in VBA

    Hi Guys, I want to export each row of my selection range as separate image in VBA. Image name will be from the first column data. Like as, S1001.jpg, S1002.jpg & go on. Is it possible? If yes, give me some idea with the code.
  4. A

    How to auto delete cells every day

    So I'm trying to create a leave/vacation tracker for my employees/coworkers, and I want to automate the worksheet so it automatically deletes(and shifts) certain cells every day. This is so the tracker remains up to date without anyone having to physical delete the cells themselves. There is a...
  5. S

    Excel VBA Find based upon multiple criteria

    I have some code, that when run from the current workbook (a template), it opens a different predetermined workbook (Sales Log), performs a find in column "A" in the Sale Log to determine the corresponding row of the item # from the template, and places certain results in the Sales Log in that...
  6. G

    Count number of rows and columns in range

    I want to get the number of rows and columns in my "selection" range, but for some reason Columns.Count returns 1 when I have multiple columns selected. Anyone knows why? I am using excel 2013 32 bit. Sub test() Dim sourceSht As Worksheet Dim targetSht As Worksheet Dim Table As ListObject...
  7. S

    Mkdir on network location causes a debug error

    I have two snippets of code that work just fine locally but seem to have issues when run over the network. When I run the code from within my LAN, it captures a directory location (Path), checks to see if that location exists, and if it doesn't, then make the correct directory tree. The...
  8. A

    VBA runtime error : Why am i getting an error while sending mail through outlook using mailenvelope

    I have a code for sending multiple emails on one click to several email id's. The code works absolutely fine if the data is limited, however if the my data sheet contains large amount of data then it throws a run time error as below: "Run-time error '-2147417856 (80010100)': The operation...
  9. D

    VBA AutoFilter: multiple criteria; array; does not contain

    Hi Folks, Firstly: all this is for a dynamic table called StockListTable. I have a Column (Header = Owner) containing numbers representing customer numbers (1 to 150 plus 998 and 999). I wish to filter out the following customer numbers---0, 27, 72, 84, 100, 998 and 999---thus leaving all...
  10. M

    Compile Error: cant find library or folder (DATE) in VBA

    I am running a macro in excel and i am having trouble with this error popping up and highlighting the Year(DATE) formula in my vba. i have searched and searched and have found things on how to replace the referrences but i dont know what reference to use to solve this issue. my program runs...
  11. S

    Convert incell formula to VBA code

    So I have a pretty complex formula that I am using in some workbooks. I would like to convert them to VBA, but it is way over the 255 character limit that .Formula allows. I know of and have used the replace option before, where, for example, you have a formula: =If(AAA,bbb,CCC) You replace...
  12. S

    Need some insight: Previous code not working

    I have some code that works just fine for sorting and filtering a workbook that contains tables. I have tested it many a time recently and it works as I need it to. I run the code from within a module in the workbook where the data is located. Let's call this workbook 1. However, I now need to...
  13. S

    Convert Range vba code to ListObject vba code

    So I have some code that I have been using for about a year. It works great!! However, it is for a workbook where all the data is in range format. I recently re-built the data structure from the ground up in a new workbook, and implemented tables. It has made things much nicer and easier to...
  14. Small Paul

    VBA Copy Worksheet to Another Workbook

    Hi I have 2 workbooks. Workbook A contains 1 worksheet. Workbook B (purchased items) has a variable number of worksheets. I need to copy the worksheet in A and add it to be the LAST worksheet in B. The code I have at present is: Sub Macro1()' ' Macro1 Macro ' activesheet.name = "Payee...
  15. Small Paul

    VBA - Save Worksheets as Individual PDFs

    Hi I have searched various websites/forums and tried the solutions but without success. I am hoping somebody here can help on this issue. The code below basically has 3 stages: 1) Create a new folder and save the master file (this works properly) 2) Save the active sheet as a pdf (this does...
  16. H

    vba to open subsite from main site

    hello everyone, I am new to vb.net... I need help in a macro, I have a site , after logging to site I want to move to subsite in it.. I tried with providing direct subsite url but after entering credentials, page gets refereshes and takes to home page only.. pls help
  17. H

    macro enabled excel vba save workbook in specific folder while downloading

    Hello all, I need help in VBA as m new to it. I have a macro enabled worksheet lets say template available at server. Whenever I click on it to download, I want it to be downloaded at specific folder itself. the code should be in that template itself. Any help will be appreciated.
  18. A

    How Do I Move Row to Different Sheet based on Selected Value

    I am trying to create a call sheet that organizes Active Leads. I am wanting to move a customer to a "Do Not Call" sheet if that selection is made. That way I have 2 separate sheets 1 for active leads and 1 for Do Not Call. But If a customer on the Do Not Call sheet changes their mind, I would...
  19. C

    VBA to convert a Tabular Report to a Matrix view

    Hi Everyone, I have a report which I generate on a regular basis and need to convert from a tabular view to a matrix view for readability. I use Excel 2013 I would appreciate if anyone could assist me with some VBA code to accomplish the following: Delete all non-required columns, in this...
  20. I

    loop through sheets in the workbook and copy specific range from each sheet to a summary sheet.

    Good morning, I have a spreadsheet with 5 or more sheets and I am trying to create code that will loop through sheets and copy the same range from each sheet to the "Overall Summary" sheet. The range should be copied into the next blank row. Here is the code I have so far, please help. Thank...

Some videos you may like

This Week's Hot Topics