newrange

Hi, Please can someone help me? I am trying to put together a code to do the following: 1. Checks for any blank cells in my range 2. Then checks the values of them cells against the cells with the values that shouldn't be exceeded without a reason. Here is my code so far: Sub...

The VBA below can get the printout in one pdf: Sub PrintInOnePdf() Dim selectionRange As Range Dim newRange As Range PrintoutPath = "C:\Users\DK-01\Desktop\Scan\" Set Sh = ActiveSheet which = InputBox("Print which pages?") NameOfFile = which 'before splitting "which" which =...

Hi All, I wrote this macro but it seems to be duplicating the data. Could I get another pair of eyes to help me find the problem please? Thank you. The output in column B is correct. The output in column C is correct. Column D is a duplicate of column C and what should be in Column D ends up...

The VBA can do the following: 1. Input print pages (e.g. 3,6,4) 2 .VBA can print out as pdf all input pages, but not in order (i.e. 6,3,4). How to modify the VBA so that the print out is in order of input pages, i.e. 3,6,4? Sub PrintSOR() On Error GoTo 1000 ro = ActiveCell.Row co =...