Good idea, bt u might want to make what u r typing is visible to us. No one can see such a small screen even in 1080p resolution!!
@cogwheelLearning
3 жыл бұрын
Awesome tutorial Nik! It would be great if you could zoom in a little so the cells appear bigger. Pretty hard to see on mobile this way. ✌️
@FinanceNik
3 жыл бұрын
Hey there! Thanks for the constructive criticism. I'll do that next time!
@cogwheelLearning
3 жыл бұрын
@@FinanceNik Super! Looking forward to your next video. Just subbed
@FinanceNik
3 жыл бұрын
@@cogwheelLearning Cheers mate! That really keeps my motivation going!
@valentinaledesma8776
2 жыл бұрын
Thanks !! That was very useful, although, I suggest to zoom to your code in following videos, it was a litle hard to read .-.
@Leonscott80
Жыл бұрын
Perfect Tutorial, thanks so much!
@maxivy3299
3 жыл бұрын
Amazing tutorial. Very clear.
@annemullender6724
3 жыл бұрын
Great video, dude!
@rubenpedersen5483
2 жыл бұрын
Hi Nik! Very useful video. But one thing I've been thinking about and not clear out yet; How do I write the code when I want the individual cells in row "c" to keep the data they receive from, for example, cell "a1" My problem is that "a1" is updated against live data every 60 minutes. At the next update, I want to keep the data and store new data in the cell below. I have created a script for a new cell every 60 minutes. But has not solved this with the fact that the stored cells are not changed by live update. Well I hope you have an idea :)
@KleanthisSkoulikaris
3 жыл бұрын
Wow, things are getting serious now. We started adding "swag" to VBA! 😆
@FinanceNik
3 жыл бұрын
Haha, thought I might try and add some flavor to the relatively dry content
@barryc7443
3 жыл бұрын
Zoom , can’t read the code because it’s too small
@norbster369
7 ай бұрын
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!
@johanlompieslombard3803
Жыл бұрын
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
@bibeo2493
Жыл бұрын
Perfect!!!
@_.Alok._.jha._
6 ай бұрын
What is the size of your desktop 🤔
@MovingFwrd
2 жыл бұрын
Can you disregard download link example xls
@ProjeAdam.
2 жыл бұрын
bro I want to work macro when changed now time cell but not working
@1le0nard0
10 ай бұрын
i have the same problem with today can someone help me?
@mirrormefashion
7 ай бұрын
Finally found the video I need but I can't see a single thing you're doing 😫😫. Very unfortunate.
@FinanceNik
7 ай бұрын
I get you point, but you could try pinching your fingers to zoom in if you are watching the video on a smaller device. Typically also works with the KZitem app. Hope this helps!
@mahadevtengse4970
10 ай бұрын
Need help with macros because my data range always change sometimes its 1000 rows/coloums or somtime its more than that or sometime less
@FinanceNik
10 ай бұрын
Hey, could you give me a little more detail about what you are trying to do?
@DJSimNRecords
3 жыл бұрын
Als je iets meer inzoomt kan ik het beter zien!
@edwardrambanpinem1359
Жыл бұрын
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
@FinanceNik
10 ай бұрын
Hey Edward, so what you could do it write a little script that always finds the last populated row in your excel sheet. Then, when you want to add data to that sheet you just insert it one line below the last populated line. Cheers
@GilmoreAntalan
3 жыл бұрын
why would you not make the screen bigger. only you can see what you are doing.
@FinanceNik
3 жыл бұрын
chill, ma guy. I have done it on a desktop and if you would be watching the video on a desktop too, it would be visible for you too. However, I will take your constructive criticism and zoom in next time I'll record a video
@tanujsharma2812
3 жыл бұрын
I need a code in vba that pastes a range from sheet 2 to sheet 3 automatically when any value in that range changes Please help.
@FinanceNik
3 жыл бұрын
I will try and get back to you!
@kamrulzoha9223
2 жыл бұрын
I am doing the same 🤣 But Its hard for us to read what he wrote in code at last I get an error Intersect
@kamrulzoha9223
2 жыл бұрын
Sub or Function not define
@kamrulzoha9223
2 жыл бұрын
For your code We need 4 Glasses 🤓 Make something which we can read 🤣 Already some ppl like me Don't want to use big screen mobiles and your code very hard to read . Hhhh
@FinanceNik
Жыл бұрын
True that! Thank you for your constructive criticism. I'll get back into it and incorporate some zooming in!
Пікірлер: 35