Recent Activities

Hi,

I need to split a long text entry to 2 columns which are limited to 30 characters each + any remaining text will be placed in 3rd column.
The text needs to be split by whole words (so the split will not be done mid-word)

See attached for reference
-…

Dates and match are always entertaining. Try using:

(Code, 1 line)


I'm assuming you know your initial d date is 4th Aug 2019.

Dear Guru's,

I need some help with an IE automation where in I have to click on a popup dialog box as "yes" and then proceed to other procedures.

I am stuck upon the dialog box where I am unable to get the element of the button as there is no ID of the…

Frank, that will not protect the code.

Even workbook protected with Unviewable can be cracked.

Standard VB Editor protection will deter most users.

When the form collapses you then select the range to work with. All the coloured ranges in the example worksheet were created with the userform.

You are welcome

You are welcome

Thank you so much Carim!!!! ill try your idea later but its very helpful and Smart your answer!

Hello,

It seems to me you could simplify your approach :

By setting up your criteria in a way that enables the AutoFilter to only display the specific 5 rows you do need to delete ...

Hello,

It seems to me you could simplify your approach :

By setting up your criteria in a way that enables the AutoFilter to only display the specific 5 rows you do need to delete ...

Hello Mumps. Many thanks for your assistance. It works perfectly and worked even with one range that did have two cells merged

Have a nice day and thank you once again!

Best regards,
ThanPanag

You have merged cells in the named ranges. You should avoid using merged cells as they almost always create problems for macros. Start by unmerging all the merged cells in your named ranges and then try this macro:
(Code, 8 lines)

Hello and Welcome to the Forum

Do not how familiar you are with Excel ...

But Merged Cells should simply be TOTALLY BANNED

Just get rid of them ...

(Quote from xchorok)


Thanks a LOT for your very kind words .... AND for the Like Like Like  

Hi,

You could test the following

(Code, 9 lines)

Hope this will help

Hello again!

i want to delete an specific number of rows after i filtered using autofilter im using the following code


The main issue is that after sorting the data on the other worksheet the code erase all the filtered rows visible, but i want to know if…

Hi all

I have assigned a macro to a radio (print) button that will print a specific range (report) and insert a timestamp in a dedicated cell to indicate the date/ time when that report was printed (using the =NOW() function)
There are multiple buttons…

I have 2 merged cells, B1 and C1. After putting data into these merged cells, upon hitting Enter I want the cursor to go down on the right side of the merged cells and land in C2. In Options/Advanced you can direct where the cursor goes, down, up, left,…

I just lost my word. This is PERFECT!! Thank you so much Carim! Like Like Like!

Hello,

Attached is your Test file ...

Hope it is in line with your expectations