Відео

Dibbert Fords

Thank you so much!!!

thank you.

You explained each step so well, and I really love your "no hard code" idea!!! Thank you for such a effective tutorial💯🎆

great explanation, thank you

Thanks!

Why do I choose data in the IQY format in Excel, data like in the video at minute 3:06? Cannot be selected.

when I save the document on word I use the scroll down window and hit .txt but there is no where to delete the .txt and put .iqy. It only lets me change the name. Can someone please help?

What is the size of your desktop 🤔

plzzz can you do it again with current version

My question is can I do this with any site? Or there needs to be a specific API key somewhere in the website?...I want to take data from the JSE stock exchange so I can build a project around ir

is it possible to change color on smartart as well thru vba? thanks

Hi I'm trying to automate the publish and refreshing action buttons in team ribbon, can you suggest the macro for this..?

Finally found the video I need but I can't see a single thing you're doing 😫😫. Very unfortunate.

Using MS Office 365 for Mac. Followed all your steps and the macro did not trigger. Macro is part of a module and the cell change event trigger is under the sheet where the cell value changes. The macro runs with no problem when manually triggered, but it seems like excel does not recognise the cell value change. Ideas? Thanks!

sir the font is si small nearly invisible pl enlarge whic could easily be watched dont mind sir

Kia Ora! Thanks for a very helpful video. How would you edit the code to delete cell that have a value after a particular date? Eg. delete dates after 11/06/2101 (dd/mm/yyyy) from a data set

What's wrong, it won't delete the rows in column A with the words Date in them. Nothing happens actually. Sub DeleteRowswithTextDate() For i = 1 To ActiveSheet.UsedRange.Rows.Count If Cells(i, 1).Value = "Date" Then Rows(i).EntireRow.Delete End If Next i End Sub

thank you! i found this helpful

Good video man but your keyboard is loud asf

Need help with macros because my data range always change sometimes its 1000 rows/coloums or somtime its more than that or sometime less

Nice vid, i've been trying to find a easy solution and here it is. if you are having the same problem that excel wont recognize it as a iqy just do this (This is an extract of someone else comments) : ""Find the file that you saved with the .igy extension. Right click it and select 'Get Info'. Navigate to the 'Name and Extension' tab and I suspect that you have to delete the '.txt' suffix. Once you do, the OS will ask you what sort of file type you want to save the file as--.txt or .iqy. Select '.iqy'.""

that is cool, simple but useful, powerful...

Thanks

Hi Thank you for the video - it was very helpful. I have a question - is there a way to do the same for text file (.txt extension) search 1st word (text) and search 2nd word (text) and in between the range want to remove and save the file - PLEASE advise! Thank you for your help! - Dalpat

Thank you very much, it helps a lot

Hallo Sir, i have excel data come from scanning Barcode that content HTTPS link. Now i klik every single line of data to insert Barcode content to Google Form. All data at A colom. How to automate it when new line data come. Thks

Good day. Thanks for this excellent site where I can get meaningful solutions. However, when I type the routine that call the macro, exactly like in the example, except for variables, I get an error on the following line: If Not Intersect(target.Range("O2")) Is Nothing Then Here is the error message: Compile Error: Argument not optional

Perfect Tutorial, thanks so much!

Perfect!!!

This was super useful, thank you!

Thank you man, it was super helpful!

you could just do a find on the date rather than splitting, but thank you!!!

Hey thanks man. I got stuck where I couldnt import some matplotlib, little bit of googling showed me the commands to run. This was a big help, Im suprised your channel isnt larger, Have a great one

good.

Thx

Very useful, thanks

little fyi you have to install requests with sudo pip3 install requests

❤️‍🔥👍

This didn’t help 🥴

Hi ) amazing work! Can you make please a video about counting cells by color using Vba or some formula =countIF(A1:A100,”red”) thanks 😊

nice one! Keep it going!

Please do more videos

Is it possible only the some rows rather than entire row.. Expecting reply

Heiii, thanl you for that!

Perfect the “messing link”

can you make a video in which one column data continuous change by time , that record we can and also time column changes according to that 2 column we can make automatically 5 min frame data in different row as open high low close that we can use in stock market

good vide. I was able to follow. Nice

Hi, I am getting type mismatch error when I try to include OR so that I can search and delete multiple names

Hi! I have a workbook which contains 17 sheets. This workbook is a type of work schedule where I can enter a start date which usually begins a new year. In each sheet which is based upon a 24 day work schedule I need the sheet to calculate the days of the 24 day/schedule as well as the day of the week. I need the name of the sheet to change to reflect the range of dates for each sheet. Next I need for one row the cells for Saturday and Sunday to change color. The parts that I have not been able to work are renaming the sheets based upon the start day and the changing of the cell color. What do you think?