startrow

Hi, I have this below code which works perfectly fine. I need help to achieve 3 more tasks. 1. The number of attachments should not count if the file extension is png 2. The files with extension png should be shown or exported 3. Is there a way that the attachment(s) itself can be...

Hi Everyone, This is a slightly different request to normal as I have a working macro but feel its not very good and was hoping someone could help me make it better. The Macro Opens another document copies data and closes it again. I Use this type of macro all the time as I have a lot of...

Hi everyone, Im relatively new to VBA, and struggling a bit with the syntax. Hope someone can help! What im trying to do is this: I have 3 sheets im working with, lets call them sheet1, sheet2 and sheet3. Sheet 1 is input data in which I want to look up a value, for every row in sheet 2. Sheet...

The below code allows me to select a folder from outlook and pull some information from it. I didn't create this code - someone way more intelligent did! What I'm having issues with is getting rid of the selector for folder; I want to specify a mail folder within the code that will never vary...

Thanks in advance for any suggestions and I will post feedback! The code should do copy and Paste Transpose seven times, but it only does it once. Any idea why? Seems like it's not running the Loop and the issue must be with If Then Statements. The only part of my code that seems to get...

Hi all, Need help on macro to pull information from outlook. I have gone through the previous threads but not able to customize the solution to suit my need. I have taken the code / file from following link "https://www.vishalon.net/blog/expor...-meta-data-into-excel/comment-page-3#comments" and...

I have a very strange issue that I'm hoping someone can help me with. I've written a macro to automate a weekly task my wife has to perform at work. It involves sifting through a long list of raw data records and copying them to other worksheets in the same workbook according to specified...

hello all, not sure what to code I need to select the range startrow =2 endrow = 15 startcol=10 end col=50 colstep = 10 for r = startrow to endrow for c = startcol to endcol step colstep set my Range=??? .... any ideas?? Ross

Dear Sirs, I have copied the folowing module to combine all worksheets in my worbooks and it work perfectly.. All sheets have the same format and header (Copied from-https://www.rondebruin.nl/win/s3/win002.htm) In the existing VBA module the startRow for data to be copied in each...

I have a workbook and have et up a macro to send a reminder to outlook, but get a run time error "type mismatch The code below is highlighted .Start = DateValue(Range("D" & ctr)) + TimeValue(Range("D" & ctr)) See sample data and code below It would be appreciated if someone could kindly...

Hello, I've been able to find a couple macros posted elsewhere to accomplish what I'm looking for, but it does not work for all instances with items on the last row and was hoping somebody here could help me refine the macro or suggest an alternative solution. Here's the code: Sub AddBorders()...

I am trying to incorporate a variable in a CONCATENATE string in a macro. I have a loop that I want to merge 3 values using CONCATENATE with Text1 and Text2 being fixed sources eg A1 & B1 but I need to increment the 3rd value each loop. My variable "ci" is incrementing but I cannot work out how...

Hello all, Please help with an "runtime error 1004 method range of object _global failed" error, that i recieve in this vba. I have around 10 more VBAs before this one, none of them return an error, but this one (they are identical, only page numbers a different)...

Hi All I have a document that creates multiple documents in a mail merge type action. I'd like these output as a single PDF for printing later. The code I'm currently running outputs individual documents to a printer. Code is as follows: Sub Test() Dim startrow As Integer, endrow As...

I work with pivot tables a lot and needed a way to make the various datasets dynamic in case I want to add or delete rows or columns. I created a FUNCTION that I got to work once but can't seem to duplicate it. STEPS: 1. Add function to workbook 2. Create a named range Formulas/Name Manager/New...