referecing

Hi guys, I am currently working on a tool to efficiently print the logs of our production process. However, sad to say I am really stucked. Initially, my idea was to be able to select the desired .xlsx file from a directory - which I was able to do using a macro. Then...

I keep getting an application/object defined error for a line of code. I have a loop similar to this one that works fine with the same varaibles. I also reference cells in the same way in other parts of the code without error. Here is the code : For i = 1 To FLAGNUM If...

Hi there, My Name is Prathik. I'd like to apologize if this question has already been answered. I didn't find anything about this anywhere on the internet. So posting it here. Please assist. So I'm writing this code wherein my macro writes a formula in E2 (Range A To D already has data). Then...