vba & excel 2013

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...

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...

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...

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...

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...

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...

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

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.

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...

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...

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...

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...

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...

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...

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...

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 =...

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...

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...

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...

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...