vba & excel 2013

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. 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
  8. 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.
  9. 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...
  10. 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...
  11. 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...
  12. S

    ws.Protect causing code not to run .... should be simple ?????

    Yesterday, both igold & Akuini were very generous in assisting me with figuring out how to code something. We were able to figure it out (thank you again!!). Here is the thread: Push Down Rows However, now I am up against a different issue, but involving the same piece of code. The code...
  13. D

    VBA Macro to read worksheet and output 10% each category in one column

    Hi All, I need VBA Macro to read worksheet and output 10% each category from one column. Data like this Name IDs A 1 A 22 A 33 A 444 A 555 A 666 A 777 A 888 A 999 A 1000...
  14. M

    Excel VBA: Add Suffix to Specific Worksheets

    Hello All, I am just beginning to explore Excel VBA, and have written minor macros but am in need of assistance. I have an Excel document with 6 worksheets, 3 which contain the word "Detail" as part of their names. I need to create a macro that will add the suffix "-Final" to the worksheets...
  15. D

    Curious problem with a find and replace macro?

    Hi Folks, I have a column of data (column H) headed [customer reference]. Customer reference data is populated by users when they book a courier online. They have to input a client customer number (3 digits), a sales order number and a check digit, each element separated by a hashtag (so...
  16. S

    Copy data to an empty table

    Hi, Could anyone help me with the following code. It works when Table2 already contains data, but I have runtime error 91 when Table2 is blank. Why? Sub Integration() Dim tbl1 As Range Dim tbl2 As Range Application.ScreenUpdating = False Set tbl1 =...
  17. S

    Splitting Formula - Better way?

    So I have a number of formulas that are currently in-cell. I am converting the workbook to VBA and so would like to use the .FormulaArray and .FormulaR1C1 to place the formula in the columns. However, I have found that those two pieces of code have a 255 character limit of what they can place...
  18. S

    .FormulaArray - Missing End Curly Bracket - Normal?

    So I noticed that when I use .FormulaArray to input an in-cell array formula, in the formula bar I see the formula starts with a curly bracket "{". But I don't see one on the end. Normally when I input an array formula via CSE, there is one at the start and one at the end, to identify that it...
  19. S

    Why do I get this VBA error message?

    I have a table ("Fruit") in sheet "Fruit" which is comprised of the header (row 1) and then a single row in the body. The columns are: Apples Bananas Total Fruit I have no data in row 1, it is simply blank. If I input the following code into a vba module, it works fine. Sub Fruit() Dim...
  20. S

    Better way to input formulas in tables?

    So I have 8 different tables, some with up to 65 columns, others less. Current I have formulas in the columns for those which need formulas. I kind of want to transition away from having the formulas in-cell, where they can be changed, erased, etc., to having them be coded. However, I am...

We've detected that you are using an adblocker.

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.
Go back
Back
Top