Problem with range

Originally Posted by pike

Hi crysis.warhead
can you please add code tags as it will make the code easier to read

Hello,

thank you for answer. I didnt explain my problem well, I am sorry. Well, the problem is with the KOD1. I wish to put 4 numbers in cell C3 (this numbers should filter collumn CAROVY_KOD by first four numbers [normaly there is about 8 numbers]), start this macro, and it´ll gain information from db (V200901) and put it into the sheet.

If i dont use KOD1 and put numbers manualy, it works perfectly. But in the case I use KOD1 connected to cell C3, it doesnt work No error, but it load only name of columns and no data.