Recent content by houde

Hey, thank you very much, this helps a lot!!!

Hey, That's a good tip, I'll try it out. I added another loop, and it now actually increments from line 17 to line 18, but then it bugs at the line "Else: Cells(i, k + 1).Select", and when I click on the k, it sais 256. I don't understand why it even goes to k=256, since I limited it to...

Hello! Does anybody know how I can make the row index (i) to increment by one, once the cursor has reached the 101th column? What I'm trying to do is to delete all cells that contain the value 99 and shift the contents to the left. This should be done in all cells from Cell(2,2) unitl...

Ey PH, It is working! Thank you very much!! I thought that this second "select" looks a bit strange, but since I had it from an other Tek-Tip thread I left it in there... Anyway, it's working now. Thanks again! Fabian

Hello to everyone, I am trying to run a query in Access that should give me a table with the following columns: Subcategory C_YTD Pre_YTD Change The column "change" should show the percentages, i.e. C_YTD/Pre_YTD - 1 I am taking the data from a table "BY DEALER & SUBCAT", so...

Hey Glenn, Thank you very much for your help! I did try the " and & but must have put it wrong, something like ("A2:D"&i&""), which obviously doesn't work. Well, now it should work. Thanks again! Fabian

Hello to everyone! I tried to write a macro that re-sets the data range of my chart in Excel to the ith row. i is defined in cell G2. I don't know why my code (see below) isn't working (I get an error "Method Cells of Object _Global failed"). Can anyone help? I would very much appreciate it...

Hey guys, Thank you very much! I am learning so much from you! I hope one day I will know enough so I don't have to bother you any more!!! Thanks thanks thanks

Hello! I tried to automate a stupid work that I am doing in Excel right now: Copying names down into the cells below that are empty. The problem is that the loop doesn't really work, it only jumps between cells C2 and C3 - anybody knows what I did wrong? Your help would be very much...

Thank you very much! Actually I tried this before, but I got a "Expected: End of statement"-error. Then I copy-pasted it from your answer and it worked... Hey, have a nice evening!! Rgds, Fabian

Thank you! I have one more question: I would like to replace 20000 by a placholder, e.g. alpha. Alpha is determined by a counter in the worksheet and tells me which one is the last row that contains data. Obviousely it doesn't work like this: Sub UC_opp_model() ' ' UC_opp_model Macro ' Macro...

Hey Geoff, You're awesome!! Resolved all my problems in 2 minutes! Cheers mate! ;-) Fabian

Hello! What do I need to substitute B2:G20000 with so the vba-code is not producing a debugging problem? Important: the range needs to be absolute, i.e. always B2:G20000 and not change when I copy it down to E2885. This is violated when I use the R1C1 notation, which is why I tried with...