Posted by steve on March 23, 2001 4:31 PM
Can anyone help, I have a userform pop-up on a before print command. I use some check boxes on the form to place print ranges on the excel sheet, I then concatenate all the ranges with the concatenate function and places the new range in cell I100. I then need to set the range as the print range. I then put the following code into the command button labeled print to try and print the range.
The problem is that its trying to open the userform again it says form already displayed and its trying to print the original print area and the one thats linked to the userform.
heres part of the code that places the ranges to be concatenated into excel.
Private Sub CheckBox6_Click()
If CheckBox6.Value = True Then
Range("Q100") = "EE1:FA35"
Range("Q100") = ""