Forum

Gob Sheite
@gobsheite
Active Member
Joined: Jun 15, 2022
Topics: 4 / Replies: 7
Reply
RE: Is it possible to trap data being drag/dropped into XL to Paste just the values??

Hi. No its a cell by cell 2 second daily grind. I just wondered whether Excel could detect/trap dropped objects just to speed things up a bit Thank...

3 years ago
Forum
Reply
RE: Any ideas how to sort a table (.ListObjects(1)) by column 3, then by column 4?

Great Thanks. And it also answered my question as to why you keep having to define the same sort range over and over, which was making me very nerv...

3 years ago
Forum
Reply
RE: Does anyone know what causes or restricts parameter prompts in VBA?

Currently I get prompts for: Application. and that's it, nothing after that, no matter what parameter I choose I used to (Office 97-2003) ge...

3 years ago
Forum
Reply
RE: Any ideas how to sort a table (.ListObjects(1)) by column 3, then by column 4?

Hi. I'm struggling to incorporate that into my existing With statements Any ideas? With ActiveWorkbook.ActiveSheet With .ListObjects(1) ...

3 years ago
Forum
Reply
RE: Does anyone know what causes or restricts parameter prompts in VBA?

but Excel does know what the Activesheet is, but has never prompted me for a parameter Ive always had to use Application.Worksheets(1). I t...

3 years ago
Forum
Reply
RE: Is it possible to just exclude a value from a filter without specifying all the other values that are included?

That looks great, I just want to exclude values that are "<>Closed/Transferred" but what is the referral to Field 7??? Ive tried dele...

3 years ago
Forum