Forum

Bob Kaplan
@bobkap
Eminent Member
Joined: Jul 29, 2013
Topics: 4 / Replies: 13
Topic
Forum
Replies: 1
Views: 82
Reply
5 years ago
Forum
Reply
5 years ago
Forum
Reply
RE: Variables do not work in RemoveDuplicates Method

No. If column C and H are duplicates to other rows of data, I need to remove one of them. So, in this case, if "email" and "year" are the same, on...

5 years ago
Forum
Reply
RE: Identify cell color from conditional formatting

Hi Phil, I just cannot get this to work. Maybe, I didn't input your suggestion correctly? When I run this macro it deletes ALL rows regardless of...

5 years ago
Forum
Reply
RE: Variables do not work in RemoveDuplicates Method

Hi Phil. Sorry for the delayed reply, I was stuck in meetings (UGH) the last few days. Here's the file. Here's the line of code that's giving me ...

5 years ago
Forum
Reply
RE: Identify cell color from conditional formatting

Thanks very much Phil. If you don't mind, can you please explain a bit about what "debug.print" is used for? I have tried to read about and understa...

5 years ago
Forum
Topic
Forum
Replies: 8
Views: 305
Topic
Reply
RE: Create and Name PDF

I figured it out!!! It was due to the "/" in my date entry. I fixed that and now I have other issues that I hope I can figure out myself to...

6 years ago
Forum
Reply
RE: Create and Name PDF

Me again, I am truly sorry to bother you, but I've hit another stumbling block and just cannot figure out what's wrong. I've attached my file...

6 years ago
Forum
Reply
RE: Create and Name PDF

Many thanks Phil!! Bob

6 years ago
Forum
Reply
RE: Create and Name PDF

Sorry. I meant to mention that I had used this code before I decided to have my output be a PDF vs printing hard copies.

6 years ago
Forum
Reply
RE: Create and Name PDF

OK Phil. I think/hope I'm almost there. But, I still have a problem or two. As you saw, I have 4 sheets that I do not need or want to create PDF...

6 years ago
Forum
Reply
RE: Create and Name PDF

Got it. I never thought of that (of course; ugh). I'll re-look at it and rethink based on your suggestions. Not sure why I decided to put the date ...

6 years ago
Forum
Page 1 / 2