1. S

    Copy multiple sheets to folder from workbook

    Hi, i have this code that allows me to copy sheet2 to a folder on cdrive from my workbook and name the sheet with the date and time. How could i modify this code to copy sheet2 and sheet4 to the same wookbook. Sub test() Sheets("Sheet2").Copy With ActiveWorkbook .SaveAs...
  2. S

    Validate Character Codepage / Font Entry

    Hello, I have an Excel workbook with 3 columns, English, Japanese, Chinese where the user enters text (basically translations) in each row. I need to create a macro that validates the Codepage (font set) for each character used in each cell. Cells under English should validate against the...

Some videos you may like

This Week's Hot Topics