Forum

Miguel Santos
@rhysand
Trusted Member
Joined: Feb 20, 2020
Topics: 0 / Replies: 80
Reply
RE: Multiselect listbox - if specific value selected, save textbox to same row, save values to cell or row

Hello, I'm still trying to figure out what you want, so I'm changing your project step by step I attached the file with just a few changes befor...

4 years ago
Forum
Reply
RE: Why is Next x in VBA not stopping when a blank line is found.

Good morning everyone, could you attach a demo of the file, without confidential data, it would be much easier for someone to help, recreating ever...

4 years ago
Forum
Reply
RE: Currency change in textbox userform to Sheet1

Hello, you can attach a demo of your file and better explain what you want to happen? an example to put any text in the cell without excel ...

4 years ago
Forum
Reply
RE: Macro written in 32 bit System - Not working in 64 bit System[ Win 10 and Office 2019 Prof]

Hello, update complete, file attached you just need to do the following when you go to write the email addresses, whether in column ("A") ...

4 years ago
Forum
Reply
RE: Macro written in 32 bit System - Not working in 64 bit System[ Win 10 and Office 2019 Prof]

Hello, sorry, my mistake change in module1 where the following part is, replace the line with this one in red If x > 0 Then For a = ...

4 years ago
Forum
Reply
RE: count consecutive blank cells

Hello, attached sample file your excel file needs to be saved with permissions for macros, that is, with the extension (.xlsm) confirm that thes...

4 years ago
Reply
RE: Excel - Print Document

Hello, another solution, using VBA put the following code in a userform module if you don't want a userform, it can be placed in the standa...

4 years ago
Reply
RE: Date format issue

Hello, an error occurred when the date (formatting or other) was inserted in that sheet of your workbook, I can change and change the formatting in...

4 years ago
Reply
RE: count consecutive blank cells

Hello, if you want VBA version: put the following in a standard module Public Sub Count_consecutive_empty_cells_in_row_2() Dim sht As...

4 years ago
Reply
RE: count consecutive blank cells

Hello, looking at the next image, the empty cells in each line between the column ("E) and the column (" AD ") were highlighted in red the seq...

4 years ago
Reply
RE: count consecutive blank cells

Hello, please clarify what you really want, in your Post 1, you say " here we need to count the consecutive blank cells only, which appear t...

4 years ago
Reply
RE: count consecutive blank cells

Hello, added a userform with result by msgbox, and added a command button on the sheet with result in column ("A") attached test file Miguel,

4 years ago
Reply
RE: Macro written in 32 bit System - Not working in 64 bit System[ Win 10 and Office 2019 Prof]

Hello, I changed the attachment line in this attachment, for each email line to be sent, the attachments will be from column ("D") to column ("J") ...

4 years ago
Forum
Reply
RE: Macro written in 32 bit System - Not working in 64 bit System[ Win 10 and Office 2019 Prof]

Hello, new macro was made to send email through Outlook the macro will analyze each line of the sheet where the mailing lists are email will ...

4 years ago
Forum
Page 2 / 6