Search results for query: *

SkipVought, Thanks for that precise and focused answer to my question, what I should have said was could someone please point me in the right direction as to how this could be done. Thanks Cutter

Hi all, Running Windows XP, Excel 2003 I have a workbook which has multiple pairs of worksheets. In each pair their is a data sheet and a sheet which contains corresponding pictures. Each record in the data sheet may have anywhere from 1 to 4 pictures associated with it. DataSheet In column...

Hi all, Running Windows XP, Excel 2003. I have written a macro which creates new worksheets, allows the user to enter the name for the sheet and then creates a hyperlink to the new sheet on a menu worksheet. The hyperlink is inserted in the next empty cell in column B (starting at cell B7)...

Thanks heaps SkipVought, I incorporated your code into mine and it does exactly what I wanted. Thanks Again Cutter

Hi all, Running Windows XP, Excel 2003 I have a macro which allows me to insert pictures every nth cell with a predefined starting cell. As more pictures need to be added at a later date I need to facilitate the insertion of pictures after the last picture inserted and at the same intervals...

Hi SkiVought, I actually ended up removing that line completley, it was not required. And yes when I removed the dot it referenced the original sheet not the sheet selected from the combobox. Thanks Cutter

Many thanks PHV, Apart from a couple of missing brackets on the following lines Do If IsEmpty(.Cells(lrow, 2)) = False Then lrow = lrow + 1 End If Loop Until IsEmpty(.Cells(lrow, 2)) = True and having to remove the . from in front of...

Hi all, Just a preface, as with so many I am new to VBA coding and will appreciate any constructive criticism/suggestions. I have a user form which includes a combo box which is populated with a list of worksheets in the workbook. Only worksheets without the number 1 in cel BB are included in...