xindex

  1. F

    VBA line to automatically click ENTER in script

    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()...
  2. K

    Have VBA to link to cell on previous sheet, need to modify to link to last cell in column, eliminate seperate cell

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

    Modify VBA Code To Do Nothing When Clicking Cancel

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

    VBA - Customizing PDF file name and attaching to email

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

    Finding External links

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

    Extracting Number (Numerical) and Text (Textual) Portions Of An Alphanumeric String Into Separate Columns

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top