Problem entering text into reply window in Excel Questions

[Scott T]

In the browser. It looks like MS does not have compatibility mode in Edge but IE 11 does.

 

[My Aswer Is This]

In the browser. It looks like MS does not have compatibility mode in Edge but IE 11 does.

Thanks. All operating systems have their problems. And everyone likes their OS.
I like some features in Edge.
I can deal with the problem I have here on this Forum.
I saw a posting on the Web about this issues and MS said they were aware of the issue.
When they might fix it is who knows.

Thanks for your explanation.

 

[Peter_SSs]

.. Windows 10. And or using Edge

Any code I write using Excel and then when I copy code and try to paste into this forum will not paste in.

I normally use Chrome but am doing this with Edge, using Windows 10, and copying directly from the vba window to my reply here.

Sub Make_Tables()
  Dim itm As Variant
  
  For Each itm In Split("a b c")
    Range("ZZ2").Formula = "=search(""" & itm & """,A2)"
    Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("ZZ1:ZZ2"), CopyToRange:=Cells(1, Columns.Count).End(xlToLeft).Offset(, 2), Unique:=False
  Next itm
  Range("ZZ2").ClearContents
End Sub

Edit: Seems to have gone fine, so must be not inherently something to do with Edge or Win 10, but some particular setting(s) you have. I am using Edge 'out of the box' with no personalised settings.

 

[My Aswer Is This]

I normally use Chrome but am doing this with Edge, using Windows 10, and copying directly from the vba window to my reply here.

Sub Make_Tables()
  Dim itm As Variant
  
  For Each itm In Split("a b c")
    Range("ZZ2").Formula = "=search(""" & itm & """,A2)"
    Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("ZZ1:ZZ2"), CopyToRange:=Cells(1, Columns.Count).End(xlToLeft).Offset(, 2), Unique:=False
  Next itm
  Range("ZZ2").ClearContents
End Sub

Edit: Seems to have gone fine, so must be not inherently something to do with Edge or Win 10, but some particular setting(s) you have. I am using Edge 'out of the box' with no personalised settings.

Could it have to do with the font I'm using in The Vba editor Window

Do you have a suggestion on the best font to use in the Vba editor

When I copy the text into Notepad it looks Ok and normal font.

 

[Peter_SSs]

Could it have to do with the font I'm using in The Vba editor Window

I have no idea, I've never bothered to change it. What font are you using? I'll try it.

 

[My Aswer Is This]

I have no idea, I've never bothered to change it. What font are you using? I'll try it.

Times New Roman (Western)

 

[JLGWhiz]

Explain this more please:
You said:

Settings
Compatibility view
then add Mrexcel web site​

Is this setting on this forum Mr. Excel:
Settings in MSEdge

Or some other place.

@My Aswer Is This See post #4

 

[Peter_SSs]

Times New Roman (Western)

Let's see

Sub Make_Tables()
  Dim itm As Variant
  
  For Each itm In Split("a b c")
    Range("ZZ2").Formula = "=search(""" & itm & """,A2)"
    Range("A1").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range("ZZ1:ZZ2"), CopyToRange:=Cells(1, Columns.Count).End(xlToLeft).Offset(, 2), Unique:=False
  Next itm
  Range("ZZ2").ClearContents
End Sub

Edit: No, still no problem with that font, Win 10 & Edge.

 

[My Aswer Is This]

Interesting. Thanks for looking into this. I received Edge Automatically from MS when they forced me to upgrade to Windows 10.

It's not really a big problem since I'm using the work around pasting my Vba script into Notepad then into this forum.
Thanks for looking into this.

 

[My Aswer Is This]

I have had similar issues. Sometimes I have to use Go Advanced.
I think it may have to do with upgrading to Windows 10. And or using Edge

Any code I write using Excel and then when I copy code and try to paste into this forum will not paste in.

I have to copy the code in Excel.
Then paste into Notepad
Then copy from Notepad and then paste into this forum

This problem I had about needing to paste into Notepad then this forum has now been resolved since a new update arrived to MSEdge today. The problem was with MSEdge