Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tecnik
  • Content: Threads
  • Order by date
  1. tecnik

    Excel OFFSET help please.

    Hi there, I'm having problems trying to get the result of a cell that contains the formula below:- =IF(J18=1,"L8",IF(J18=3,"N8",IF(J18=2,"M8","0"))) into this OFFSET:- =OFFSET(L8,K18,0) So depending on dependent on a dropdown selection the value would change between L8, M8 and N8. I know...
  2. tecnik

    Query regarding referencing object on page

    Hi there, Rather than refering to an object on a page as below (by an index), I've been trying to refer the 'selected' item, however I keep getting a 'type mismatch'? Set myDocument = ActiveDocument pointsArray = myDocument.Shapes(1).Nodes.Item(1).Points I'm trying to apply this way of...
  3. tecnik

    Query about line node positions

    Hi there, I'm trying to put together a macro that moves line nodes, here's what I have so far:- Sub movePoint4() Set Nds = Selection.ShapeRange.Nodes With Nds pointsArray = .Item(2).Points currXvalue = pointsArray(1, 1) currYvalue = pointsArray(1, 2)...
  4. tecnik

    Help with Excel 'Find' please

    Hi there, I'm trying to limit the search routine, below, to only find values from one column, D for example, at the moment it will find values from the whole sheet. I've tried to limit the find a number of ways but haven't had any success. Thanks in advance, Nick Sub FindCodesV2() Dim...
  5. tecnik

    Word rectangle positions

    Hi there, I have a simple macro that draws a rectangle on the page however I'd like to change the macro so it draws the rectangle at the cursor postition. Is this relatively easy to do. Thanks in advance, Nick Here's the code:- Sub box() ActiveDocument.Shapes.AddShape msoShapeRectangle...
  6. tecnik

    Newbie needs help with Rectangle position in Word

    Hi there, I have a simple macro that draws a rectangle on the page however I'd like to change the macro so it draws the rectangle at the cursor postition. Is this relatively easy to do. Thanks in advance, Nick Here's the code:- Sub box() ActiveDocument.Shapes.AddShape msoShapeRectangle...
  7. tecnik

    Help with drawing a line between two 'selected' rectangles in Word

    Hi there, I'm trying to put together a macro in Word that will draw a horizontal line between two 'selected' rectangles in Word. Even just drawing a line on the right hand side of one rectangle, touching it, would suffice. Can anyone help me out please, I've been trying to create a simple macro...
  8. tecnik

    Newbie needs help please

    Hi There, I've been dabbling with macros in Word and trying to edit them using the editor however I've hit a little problem with one of them, here's the code:- Sub rowHeight5mm() Selection.Tables(1).Rows.HeightRule = wdRowHeightExactly Selection.Tables(1).Rows.Height =...

Part and Inventory Search

Back
Top