Recent content by dorjee

THANK YOU skipvought for your help! I ll meditate on your information..

isnt it possible that this code you wrote gives a run time error 9(because of the range..)?

skipvought, My data on sheet1 is structured into 15 columns, and the format is text for all cells although some represent numbers. but the only column i have to test to extract rows is the value in the sixth column. The code you highlighted is a code that I got from someone on the forum...

hi! Would it it be possible to examine my code and comment some errors that as a newcomer I missed? The code should extract from sheet1 the rows that have a certain value on column 6. First I have to extract the value of reference, which is the max value on this column. Problem is that it is...

hi, thanks for the response.. I am not sure I understand this solution: what i see is that We are copying from aa1 to A. But I dont see where the conversion takes place. Could you please be very kind and comment a little for me? thanks a lot

yeah well, idlike to automate that but thanka anyway. Do you know how id have to vba code to format text data in a column into number and then extract the max value? I guess i can use Value and max functions but i dont know how to wrap them into vba code(i am new to vba as you could see..) that...

hi I want to extract som data of a sheet and save it as a new excel file. I don t know the methods to call in vba for that would be very kind to give me a hint' thanks

hi, i dlike to format an excel column that has numbers but in text format to number format. Then i want to extract the max value in this column and put it in an integer variable. All that from VBA. The problem is that i don t know how to embed these functions in the vba syntax. Here is pseudo...

Hi! I just need to do : I have a sheet column with numbers formatted as text. I need to format them as numbers and put the max value into an Integer variable on my vba code. I don t know the vba syntax to use these functions... help..

Hi, i would like to import data from a spreadsheet to an Access table that is created then. The trick is that the data in excel must be formatted(it is originally contained in a single cell in each row and in text; this data should be thus formatted from one cell into several field data, for...

well, the last solution (not Find) seems to take shorter time. But I tested on 10000 rows only. when i tested on 20000, the process would end up not responding and I had to abort it. I can't use a row match solution as they are changing place from a file to another. So I am trying to figure out...

xlbo, when you wrote that the array solution would rely on matching row to row, do tou mean that each row is compared only to the row in compsheet with the same row number?

yeah well I dont know if its faster than the solution you suggested with the arrays. Could you possibly give me a hink of the code to add with arrays?

thanks man! it works

If it takes ages to do the search on +50000 entries, do you have an idea of a faster way to do the extraction?