xindex

I have a code that converts documents to PDF format. They are from a mail merge from an excel sheet. When you open the word documents it gives a pop up box and I need it to automatically click ENTER so it will continue. My code is below if anybody has any suggestions Sub ConvertWordsToPdfs()...

I have a cell on Sheet1 which contains the formula =LOOKUP(2,1/(F:F<>""),F:F) This gives me the last entry in column F On Sheet2 and so on, I have this code in a module Function PrevSheet(RCell As Range) Dim xIndex As Long Application.Volatile xIndex = RCell.Worksheet.Index If...

The following code auto numbers a selected range that has merged cells. An input dialog pops that asks for to select/provide the range to auto number with the option to click "OK" or "Cancel", when I click "Cancel" it puts a "1" in a pre-selected cell. I would like to modify the code so that...

I am wanting to see if there is a way to change the name of the attached PDF. In the code below it chooses the FileName = wB.FullName. I want to customize the name of the file to be [ Range("LearnerLFName").Value + "-" + Range("CourseName").Value + "-Weekly Report" ]. I have tried: FileName...

This snippet will create a new sheet and return all the external links but my problem is that the link it returns isn't found on any sheet within the workbook (as a formula) nor do I find it in the name mgr refs. Where else could it be and how do I find it? Thanks P.S. would be great if the...

I have a column in an export of data which contains flight numbers which vary between 5 and 6 characters long. These alphanumeric strings can be in a varied format in that sometimes they are: XX### XX###A XXX### XXX##A I have a function to allow me to keep just the text portion of the string...