rows.count

Hi Folks, I am trying to get data from multiple workbooks into 1workbook, building up a large data source. The code should open each workbook selected, copy cellsA3:AP and last row and then paste into the new workbook at the last blank row. I am currently struggling with finding the last row to...

Hi I want to fill blank cells with 0. The code below gave me error message complaining that rows.count overflow. I changed it to 1000 and it worked My question, why I got that error message, and how you would do it using your programming style? Thank you very much. Sub fillblankcells()...

hi all, the code below runs well, but wanted to see if i could omit the "range(K16:q1000)" part of the code. in every instance i need to select K16 first and then to the last row of column Q. minus one row if possible i tried rows.count -2,1 but i imagine this just goes to row 998...

Hi everybody I hope you can help me with 3 things. The VBA code below works but I think it's a bit slow. 1. ) The macro is set to run auto when Excels open (Private Sub Workbook_Open), so if a person then saves the file, and then opens it again and macro is run, the numbers get...

Set rng = ("A1:A10") For i = rng.Row + Rows.Count - 1 To rng.Row Step -1 is it mean 11-1 to 10-1?

Can someone help please. I'm trying to assign a variable to count a column of data starting from, in my case cell G197, to the last non blank cell in the column. The data is added to daily so will always change. I've been trying: nr = ActiveSheet.Range("g197", ActiveSheet.Cells(Rows.Count...