Recent content by CosmaL

Thank you all! I've used the proposed function from arnelgp !

Dear friends, i've got some cells with various string data. All of them contain-for sure- a sequence of characters like H500, H501, H600, H603 etc Is there any way to exctract only this sequence (H***) from each cell? Thank you in advance!

Thank you Isaac! Your advise is very higly appreciated!

Thank you, it's working!

Dear friends, i have the following statement in a loop. For i = 1 To 20 If (InStr(1, Range("E" & i).Value, "Valid", vbTextCompare)) And (Range("D" & i).Value >= 10) Then ... End if Next My question is if there's a way to declare as following: Dim ValidVar as range Dim ValidVal as...

I will correct everything, thanks! Path will be full now on! I think i wouldn't find the error while testing, because data.xlsm was activated during F8.

Thank you all once more for your help!!!!!!!!! :)

Is it possible to upload your file? I think i've lost something with the mods.

Still nothing. I think the problem is in both If Range("S" & i).Value = "Action" Then and inttrow I've changed it to "I" & i > '" and i got 1 result in line 4.

Sorry it's .xlsx, corrected

And after 18 should be 21, where S column is "action". It's really strange that inttrow remains 2, it should start from line 4.

I open it and then with block i copy the data from data.xlsm

introw gets incremented everytime at the end of the loop. If test.xlsx is closed, code does open it but it doesn't retrieve any data!

@Isaac, silentwolf If i remove the loop and use the cursor line it will copy the data. @Gasman with break and line by line it's working fine!

Dear friends, I have 2 workbooks. 1st contains the data and the 2nd contains specific cells from 1st workbook. Code is runing under a button in the 1st book. It's working for each raw manually, if i don't use the loop. Using the loop it doesn't copy anything. Any ideas? Sub...