Forum

Hi, You should take the account from session account objects: .SendUsingAccount = myoutlook.Session.Accounts.Item(2) You can find the account nu...

Hi Howard, you should loop through that folder outside your CreateEmail procedure, collect files, when they reach your limit, create an email. S...

Hi Alan, You did a great job with detailed explanations, thank you for that, we all have preferences and habits. Indeed, it is hard to see the differe...

Similarly in the last two, Cells.Item(1, 1) is the proper way to write Cells(1, 1) Why is that the proper way? TypeName(Cells.Item(1, 1)) returns...

In this case, you can use a loop, but change the processed sheet: For Each ws In ActiveWorkbook.Worksheets ws.Range("F19").UnMerge TEBAL.Range("C1...

The problem is in LEN functions, you have references not properly qualified: Len(Range("C4")) Should be: Len(TEBAL.Range("C4")) If you don't ...

What is wrong in your file?

You're welcome 🙂

Hi Marsil, The Replace method has more arguments, one of them is MatchCase, that's what you should use.

Is it something wrong in your code?

Hi Lee, Without seeing what you did, we cannot say why. It will be best if you upload a sample file with your attempt, will be much easier to help ...

I'm confused. "Can anyone help me in using VBA to selectively include / exclude queries from “Refresh All”?" Is it the code for identifying...

Hi Elisabeth, Excel can read 15 digits, longer strings needs to be formatted as text, not numbers.

Did you edited the Sample File query? Normally, this should be a sample file, not a folder: Adjust the path to your file: let Source = Folder.F...

Try these codes: Sub HideUnhide() Dim i As Long, HideRng As Range, HideStatus As Boolean i = 1 Do Until Len(ActiveSheet.Cells(1, i).Value) = 0 If...