application.goto

Hello, I need help with some VBA coding, my requirement is: I need to copy and paste ranges from 21 excel docs in a folder to a Master workbook within relevant named sheets. I have some code, but want to loop it so it runs through each of the docs and copys+pastes the relevant parts into the...

Hello, I need help with some VBA coding, my requirement is: I need to copy and paste ranges from 21 excel docs in a folder to a Master workbook withinrelevant named sheets. I have some code, but want to loop it so it runs through each of the docs and copys+pastes the relevant parts into the...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/>...

Hi, I am trying to set up an Index where I can direct my VBA code to copy the correct line to the clipboard so I can paste it elsewhere. When I use a number for the row it works but with a variable it doesn't. (But I need the variable for the For/Next because it will change as the user adds and...

Running Excel 2010 Here is my code: 'Select the correct Range to copy and copy into the sheet Set FromRange = Workbooks(Info.FromBook).Worksheets(TEMPLATESHEET).Range(NumHeads) Set ToRange = Workbooks(Info.ToBook).Worksheets(Info.ToSheet).Range("A" & RowTo) 'Copy the template...

Hello, I'm trying to get cell from a dropdownlist to act as a shortcut to a cell on another worksheet. My dropdownlist is in cell c8, and consists of cell text which are mirrored on sheet2 in column B. I named that column intList, and so far the UDF only takes my to cell b1 on sheet2. How do I...