Search results for query: *

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...

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...

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)...

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...

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...

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...

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...

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 =...