Recent content by alexsheehan

Thanks very much for your help guys. Debraj - This is just a typical example of me over-thinking things, your code Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) ActiveCell.Offset(, 1) = ActiveCell.Offset(, 1) * 1 + 1 End Sub works like a dream when the hyperlink is...

Hi folks I currently have a column (column D) with a list of names and the names are clickable with the =HYPERLINK() formula;- =IF($B7="","",IFERROR(HYPERLINK(A7,VLOOKUP(B7,Database!$A:$AH,12,0)&" "&VLOOKUP($B7,Database!$A:$AH,11,0)),"")) The cells all function and take me to the...

Thanks Hui! I haven't looked into the first item you mention in too much detail, but as far as I can tell, this is not really what I am looking for as it is pulling data from webpages into a single workbook, rather than opening up several windows for each page (please correct me if I...

Hi folks Does anyone know if it is possible to create a tabbed browsing interface for workbooks within Excel VBA? There are some add-ins available online which are (as far as I can tell) all 'pay-for' items but I was just wondering if this feature would be achievable in VBA? Most of the...

Hi Don (Fori?) ;-) You may be right, however, I don't think there is any way of policing this unfortunately - I find these forums extremely helpful and although someone may just "give the code" to me to use in my project(s), I do try and go away and actually see what the code is doing rather...

ok, the code I have (in my "IncidentsDashboard" WorkSheet so far is... 'Option Explicit Private Sub Worksheet_Activate() Call LockScroll End Sub Private Sub Worksheet_Deactivate() With Worksheets("IncidentsDashboard") ActiveSheet.ScrollArea = "" ScrollArea = "" End With End Sub...

Thanks Luke This works, to a point... in that I can successfully navigate from "Dashboard" to "IncidentsDashboard" via my hyperlinks, and this successfully selects the correct range (in this instance "W40:AC55") "IncidentsDashboard" but when I select a hyperlink within the selected range...

Hi all I have a "Dashboard" worksheet (menu) with hyperlinks to all schools within the area, each hyperlink goes to the appropriate section of an "IncidentsDashboard" tab which contains incidents of Bullying/Racism for a particular school - for example, clicking on the first school name will...

Hi Jenan Sorry, a bit late to this party I know, but according to;- http://www.dailydoseofexcel.com/archives/2004/12/22/page-of-pages-in-a-cell/ 1. can be achieved through careful use of a 'Defined Names' trick (and careful planning of course). Hope this helps, let me know if it isn't...

Thanks Narayan & Hui - points taken guys and acted upon (well, mostly) regarding the rearranging of code. Dim's now all situated nicely at the top of the code, duplicate PrintPreview code now removed and tidied up a bit, etc., etc. - here is my revised code;- Sub Main() Dim Counter As Integer...

Hi everyone Apologies in advance for the lengthy post, my code is quite long. Could someone please take a look at the code below for me and firstly, see if they can fix a couple of things that aren't quite working the way i want them to, and secondly, see if the code can be streamlined in...

Hello there! I have managed to create a way of mail-merging in Excel using an earlier version of my code below, basically pulling in large amounts of data incrementally to the same template "form" and then printing each in turn to a PDF. However, what I wanted to do was try and combine/merge...

I have decided to use the solution posted at http://www.j-walk.com/ss/excel/tips/tip92.htm, however, although this works wonderfully well, I would like to add the feature to print all pages as part of the same document, i.e. not separate print jobs as currently available using this method. Is...

Hi folks Sorry for the late response to this one, but I have only recently wanted to utilise this feature myself and came across this post. I have followed the instructions given at J-Walk as posted above and everything works beautifully, however, I would like to add the feature to print all...

Thanks Luke, Yes cell "C49" counts the number of records which meet the SearchBox criteria and the main Database list (the whole database) is in range "$A$51:$BE$127". Unique Reference for each indicator starts in column "F" ("F51:F127"). The "Filtered List" (filtered from SearchBox...