chr10

I have a very large program and i am getting error when running. Can somebody please help me how to fix this problem. Getting error when it is pasting to "D1" Error message says: Run-time error '1004' You can't paste this here because the Copy area and paste area aren't the same size select just...

Good Afternoon, With help from people on here and Google I have created VBA to issue an email based on a form that is completed. The VBA runs (stepped through) with no errors but doesnt send anything via Office. I am using Excel 2016 I think, but I am missing something but I am unsure what it...

Good Afternoon, I am able to email info from a range in a sheet from a copy and paste point, but I would like to make the email more readable. I have looked on line, but am having a bit of trouble with this The code below puts all the information in the email but I would like to space this...

Merry Christmas to all at Mr Excel, Hope you're working as hard as I am over the festive/holiday season :laugh: Trying to write a few ODBC queries into an old IBM AS/400 / iSeries server. It's all gone well using fixed values, but now I'm trying to add in some variables, it's getting a bit...

Hi, my name is Andrew and I am new to this forum, hope I do everything correctly, I have a macro that extracts data from Access. before the data lands in the excel worksheet, I want to filter the data by a variable that is defined in a cell reference. I have tried to use a dim option but I...

Hi, I have inherited a nice excel sheet that captures any issues identified on our production site and assigns an owner who need to action the issue. The code is supposed to email the owner everytime the sheet is closed down. However this email function isnt working. i have absolutely no idea on...

I am trying to merge cells from several rows similar cobbling together code from the response from Michal M to the post of Robert Dino on June 25, 2017. See link to post below: https://www.mrexcel.com/forum/excel-questions/1011345-how-merge-these-cells-quickly.html?highlight=Merge+Cells In...

Hi, Long time lurker, first time poster. I'm am trying to populate the "comments" of a cell based on a combination of cells on another sheet (don't ask!). Anyhow, let's assume we have SheetMain & SheetDesc. What I will want is for the comments on SheetMain to be taken from a number of...

I need to import data from notepad but I need the source notepad file to be selected by the open file prompt. I tried using the macro recorder but I can't get it to adjust to the variable. And does anyone know the character [10] and [13] means? The commented out part of the code is the original...