Hi
I have got a worksheet that I have a macro that creates a PDF of certain pages. It has been working fine but tonight when I hit the create pdf button it came up with a printer setup dialog box. My actual HP printer is now not there!
I tried it on another machine (which runs excel 365...
Hello
I have this code that works very well.
It runs in column E to the last occupied cell of Column J.
Now I need a new code that does the same but runs only on cells in column E if they have information and if column J on the same line has no information
Thanks
Isabel
Sub no_more_ND()...
Hi,
Andrew recently gave me a hand with an Excel formula I had been working on to automatically construct an SCCM collection query from a list of computer names entered in column B of an Excel 2010 spreadsheet (found this thread here...
I need to count backwards the runs of occurances of consectutive Ys (yes's) which are interupted by Ns.
So for example we have:
<tbody>
Months:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Ys &Ns
Y
Y
Y
Y
Y
Y
N
Y
N
N
Y
Y
Y
Y
Y
Y...
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.