microsoft.public.excel.programming | Forum profile

  Cheers. If this post helps click Yes --------------- Jacob Skaria "Seeker" wrote: > Hi Jacob, > I found the reason, changed Row(IngRow).Delete to Rows(IngRow).Delete, now > it works. Thanks very much. > Rgds > > "Seeker" wrote: > > > Hi Jacob, > > Thanks for your prompt reply and sorry for the duplicated post as it...

  Save the add-in to a shared location - users can go to tools/add-ins and browse to your add-in, copying a copy to their C drive when prompted. To create a menu, use something like the following in the workbook open event: On Error Resume Next Application.CommandBars("Worksheet Menu Bar").Controls("My Menu").Delete On Error GoTo 0 Dim wsmb As CommandBar Dim myMen As CommandBarControl Set wsmb =...

  Hi, Try this which assumes your data are in A2 - B2 =B2*LOOKUP(A2,{"B10","B12","B16"},{0.000616,0.000888,0.001579}) You can add more conditions to meet the requirements of your 'etc' "Big Davie" wrote: > Hi > > I hope someone can help with the following little problem of calculating > Column 3? > > Column 1...

  You'll get an error if you aren't on the worksheet where the line is. Have you checked that? -- HTH, Barb Reinhardt "MikeZz" wrote: > Hi, > I modifed a routine I found in the internet to draw lines between to cells. > It works perfectly in excel 2003 but 2007 I get the following error: > Method 'Select' of object 'Shape' failed. Run time Error. >...

  Not a problem. But my reply serves a couple of purposes. First, it tells you that you do have a response and second, it tells others that you have a response. CR wrote: > > Sorry about the double post. > It was my first post using Giganews. When I hit send on the first one I got > an error saying my password was wrong and it couldn't send. I retyped my > password and recived no error the...

  With Sheets("REQUEST LOG").cells(rows.count,"C").End(xlup).Offset(1) ..value = range("G7").Value End With the first line say go to the end (bottom) of the column, go uo to the last cell in that column, then down to the next available "dtoland" <drewtoland@gmail.com> wrote in message...

  I responded to your message back in the original thread... are you saying you can't see it? Here it is again... "No, you didn't miss anything... I did. Sorry for the confusion, but apparently I misread the original post and then made my comment based on my misreading." -- Rick (MVP - Excel) "Charlie" <Charlie@discussions.microsoft.com> wrote in message...

  Hi All, I have a userform designed in excel, and I want to pull certain info from access database based on what I put in Student_ID field. Here is what I have so far for getting fields autopopulate based on what I put in Student_ID field... What I want it to do is.. On excel userform.. when I input the Student_ID Number, I want certain other fields like, Student name, Subjects taken etc. related to that ID to auto populate from an...

  Hey Rick, I didn't understand your post under "VBA mid() function" on 11/2/09. Did I miss something? "Rick Rothstein" wrote: > How many groupings do you have? Are you trying to get rid of them all? Does > this, perhaps, do what you want? > > Selection.Rows.ClearOutline > > -- > Rick (MVP - Excel) > > >...

  I posted the response at both Microsoft and the Codecage because some of my responses at Theodecasge haven't been posted at the microsoft site. The code below take the data from a source sheet and puts the Results on the Destinaton sheet. Change the SrcSht and DestSht as required. Sub GetCounts() Set SrcSht = Sheets("sheet1") Set DestSht = Sheets("sheet2") 'put header row into...