Windows 10: Excel VBA Coding Window Horizontal scrollbar

Hello All,
I hope everyone is keeping well and safe!!

Within the Excel VBA coding window I am unable to horizontally scroll at all, using either, my laptops touchpad (two finger
gesture) or a seperate mouse wheel. It's actility pretty frustrating. I am able to press and move the scrollbar using the mouse or arrow keys but nothing else will work.....
I'm pretty stumped as touchpad two finger scrolling works in every other program perfectly.

Many thanks in advance for any ideas or solutions at all!!

Device Specs: Dell-XPS15-7590, Win10 Pro1909, 64bit, OS-Build: 18363.900, Intel17-9750H, 16GB Ram.

:)

 

Help with Excel VBA Problem?

Can someone help me code the following VBA problem:

"Assume you have a mailing list file. This file is currently the active workbook, and the active worksheet of this book has full name in coloumn starting in cell A1, with the last name last and everything in uppercase letters (such as STEPHEN E. LEE). Write a sub that counts the number of names in the list with last name LEE and then displays the count in a MsgBox. Not that there might be last names such as KLEE, which should not be counted."

Thanks!

 

DDE link in Excel crash when I open VBA in Excel wirh Windows10

Good Morning.

I,ve installed windows 10 about 20 days ago.

I've also Microsoft Excel 2007 and I use much VBA Excel and DDE links in my worksheets in Excel.

Before installing Windows 10 I use Windows XP ( with the same Excel 2007 thet I reinstall on Windows 10)

With Windows XP, some times when I need to change istructions in VBA, also if my worksheets was linked with DDE, I opened VBA VisualBasic and I can work in my VBA application.

No problems.

Now, with windows 10, when I open in Excel Visual Basic java links DDE Excel crash.

All works well ( DDE, Excel, and other software ) but whan I open visualbasic in Excel Java Crash.

Any suggest?

Thanks

 

VBA Excel Question

I'm going through someone elses code in VBA Excel - how do I know that "FIELD 16" is?

ActiveSheet.Range("$D$2:$R$5000").AutoFilter Field:=16, Criteria1:="="