range and macro

I have the following code to add a new column after the DateThru column: How do I name the new column? I also have the following How do I set the range and formula base on the column name instead of the cell number?

Hi! I would like some help in order to change the range of action of a paste picture macro I would like to paste photo in range: - L17:U17 based on the value from L3:U3 - L40:U40 based on the value from L27:U27 - L63:U63 based on the value from L50:U50 - L86:U86 based on the value from L73:U73...

Hi All, running a quick code: Basically column 49 will receive the DATE FORMAT value of column 39. What I want is instead of running from line 2 to 100000 ( For k = 2 to 100000) - to use the lastrow! In this case just to calculate in filled space dim lastrow as long dim lascolumn as...

Morning Everyone, I have looked all over for a solution, or even one I can cobble together, but it has been too many years, and it seems a lot has changed in terms of the complexity of offered solutions since I last visited! :( I have list of URLs in excel that all have a PDF as an endpoint...

Would love some help writing this macro i've uploaded the file on dropbox with more explanations within the file if it helps make it clearer. (in yellow highlights & red text) dropbox file I have two sheets. One titled 'Money', the second titled 'Data' In the 'Money' tab, there's a section...

Hi, My project is to create an Excel Personal Accounts WorkBook to replace MS Money. I'm using a Apple Mac Mini with Office 365 - OK with Excel, very new to VBA, so I'm mostly adapting recorded macros. in my 80th year this is challenging - simplicity is key:smile: Project Summary: Sheet 1...

Hi I am rather new to VBA but have used Excel for some time. I have an excel file dump of employee payslips each week. All employees are contained in the one worksheet - structure of data is regular so a search for a key cell value eg "Earnings Summary" at the start of each payslip then create...

Hello everyone. I've been struggling trying to copy data from a file that I download on a regular bases and paste this data in another workbook. I created a loop in order to select the downloaded file from the folders, after that I try to select the data I need and then paste it in the active...

I have a dynamic range, it changes all the time, and every time a value looks like so: #####-### (or in my formula I put ?????-???), I need this formula: =IF(COUNTIF(A2, "?????-???")>0,MID(A2,5,1),"") to be placed in the corresponding row in column C, because I need to extract the 5th number in...

Current: I have code that updates 4 tab (Sheet6, Sheet7, Sheet8, Sheet10) names based on cell values in range D2:D5. This range is populated with formulas, which can result in blanks and is located on a tab named “Calculations”. Each cell is associated with a specific tab: D2 -> Sheet6. If...

I have the below macro created. It cycles through all sheets in a workbook, except for X, Y, and Z. For each sheet it takes the value in cell A1, and filters sheet ABC based on that value. Then it selects the displayed values from columns A through S on sheet ABC, down as far as row 100, and...

I have this code to compare two sheets that will bold the differences between the sheets, the problem is i only want to compare from column A:Q and from row 12 down to infinity. And not the used range as specified in the code below. Hope someone can help thanks in advance. Sub RunCompare()...

Hi, I want to put different text name for value depend on to which ranges value belong. My ranges: 0 - 15: text name: "AAAA" 6-28: text name: "BBBBB" more than >29 : "CCCCC" I have below code, but I know that my condition are wrong: looking_date = ws.Range("B2").Value if looking_date < 15...

Hello Experts! I've been having a problem with creating mail sending macro from my report using MS Office 2010. I have come up with an idea to put header of the report in separate sheet “buffer” and then create a macro which will copy row’s range underneath it and then send it all in msg body...

I have an ODBC Query that pulls GL activity from our ERP system into Excel. The size of this data increases the number of rows every month. In columns to the right of this data, I copy down some vlookup and other formulas that I use to organize the raw data and do sumifs on on other pages to...

Hi all, Im not the greatest with Excel VBA but i have put together a small programme to send an excel range via an Outlook email using send keys and then to return to excel and do something else. The progamme works perfectly in isolation (Excel to Outlook -End) But when i add excel code to...

Hi all, I have a workbook that is to be sent out as a sales tool - the user inputs data and the workbook figures out estimated energy consumption - all this is working great and today I've been trying to add a pdf-export function. I have created a worksheet that is formatted so that it will be...

Hello, I have a table of data where i want to select data that meet a certain criteria and copy and paste that to a table in another range. I.e. I have a table with 6 columns. The first column is date and that is what i am using as a condition. If the date for a given row is in the past week...

Hey, new to VBA and I was wondering how I get it to vary the number of pivot lines depending on how much data there is. At the moment it is set to 4 which works most of the time, however sometimes it will only be 3 pivot lines, and the macro reports an error that it is out of range...

Hi folks. I'm trying to use VBA to name ranges, because I will have a lot of them to do (one for each client). If doing this so on a time sheet, an employee can pick the client from a drop down menu, and the next drop-down menu will give codes unique to that client. I'm using Indirect and...