Search results

No Hui sorry but there was some error in your code. But after correction also it was not working propoerly. anyway I made few changes and then it solved. thanks for all your help. you helped a lot.. I will paste the code for someone's reference. Sub ColourCheck21() Dim a, b, c, k As Integer...

thanks a lot for your explanation. Enjoy your day.

th thanks for the reply hui... what can I do for such case now?.. I have to write a similar code actually. Pls help.

hey Hii. I was trying to learn nested loop, but i encountered a problem. I have put 3 level loops. As per my understanding loop shall run 5X5X5=125 times. But it is running only 45 times. I am not able to figure out where i am wrong. Below is the code. I tried many things but its not working...

thanks a lot for your attention Mr.Kenneth. IsDate was the missing thing. I didn't know about it. I made changes as per my needs. Its working now. thanks a lot for all your help.

thanks a lot for your attention Mr.Kenneth. Well I made changes as you suggested. But I see something strange here 1) instead of replacing 12.4.2017 as 12/04/2017, It replaces it as 12-4-2017 only. And also 2) datevalue doesn't work and Msgbox displayes "Please enter date in dd-mm-yyyy format"...

I was writing a code to change date in string format to date format while transferring from userform to cell. for example 12.2.2017 would change to 12-02-2017 or 12/02.2017 would change to 12-02-2017 Code as below, but it is giving runtype error & Type mismatch errors in substitute formula. pls...

thanks a lot for the code.. really grateful to you ajesh.._/\_ its working absolutely fine.. I have two questions.. 1) Would it be possible to copy the full file name of opened file name in cell D3? 2) Can u pls. explain in what scenario Do while & DoEvents would be required.. I am not able to...

HI everyone.. Thanks for the attention. I searched everywhere but unfortunately couldn't find a solution. Either the macros written are too long or complex for my understanding. problem : I have a macro in 1 workbook and from that, i need to open another workbook, kept at some location. Cell...

Mr.vletm why are you talking like this? You could have just said that there is correction in syntax, i really did not know that i have to write dates this way in vba Format(7/20/2019, "mm/dd/yyyy")

Thankyou Mark for attention. I am asking for a solution here. How do i fix this issue because 23 july'18 is not bigger than 20 July'19.

Hey hii experts Please help with below code. I am not able to understand below problem please help! If i write... msgbox Format(Date, "mm/dd/yyyy") result comes as : 07/23/2018 If i write.... msgbox Format(#7/20/2019#, "mm/dd/yyyy") result comes as : 07/20/2019 but for below line it gives a...

Thankyou mark And Pascal for your very quick response & sorry for my late Thanks. Thankyou. Actually this is just a part of my other problem. Autofill is not an option for me. i have to solve it using "for loop" method only. But anyways thanks. :-)

Hii everyone in need to loop through a range and get the values in 2 column (using index match maybe.) My current formula works for 1 cell But i don't know how to use a for loop with it? Also when i run the code it pastes the formula in it. I don't want any formula pasted in the cells, but...

Thanks a lot hui. You are a savior like always.. :-) thanks a ton.

I wanted to update value between 2 numbers, which would update every second and would reflect in cell A1 like (say 1 to 5) 1 2 3 4 5 once it reaches the limit it will again start from 1. I don't want to increase number by pressing keys, it should be autoupdate. i am pretty sure its...

Thanks Hui.. You are the best .... Thanks Ramesh For your Code.. :):):)

Hello Everyone. sorry i dont know much VBA so I need Your help... I have a below code to Insert file Path in cell D6 Sub GetFilePath() FilePath = Application.GetOpenFilename("Text Files (*.txt), *.txt") If FilePath <> False Then Range("d6").Value = FilePath End If End Sub How do I insert...

Swapnil Thanks a loads. I was Not able to write the "Column B" Formula... Done worry about the Manual Part. I already do that a lot. Its a great Help. ... Thanks again for Your quick response...

Hii guys.. I Need you help now. I Have a table and there are 3 Important Columns : Project , Company, & Date My Data was earlier maintained as shown in table 1 where new date next to previous date. Can I Convert the table so that 1 date is below the other? Relevance column is not very...

No I am not aware of solver. I will Check on internet for it. Thankyou for the reply.

First of all thankyou everyone for all your very kind help through the website. I am stuck with a problem though and I don’t know How to solve it, would be a great help if you can. So here it goes. I Schedule meetings for a many of the managers based on the available time and due meetings for...

thanks a load guys.. u wont believe we used to waste more than 2 hours for this... thanks again..

In Column 1. (Proj), some project get repeated, some do not. What I do is , first I sort the Project with Colour and seprate the duplicate projects from Unique Projects. No Prob till here Now the the Problem Comes... For the Repeated projects, lets say A. I have to look Column M1. For proj A...

thanks hui.. thanks a ton... i was struggling for months due to this..