I have multiple simultaneously open files that have similar VBA code, and use identical shortcut keys, Ctrl+shift+V in this case. The problem is that excel97 & excel2000 does not seem to recognise more than one shortcut key allocation, and my attempt below to get each file to stamp its own...
The opposite of this is easy to do, using
Object.CodePage
however CodePage.Parent only steps up the VBA object hierachy towards the VBE.
The only way I can think of is by brute force...
For Each <worksheet & object> In ThisWorkbook
If <worksheet & object>.CodePage Is <codepage I'm looking...
Is there a concise way of doing this while executing VBA?
In VB Editor I can use the object browser, but this does not help while the code is executing.
For example I might have a number returned from a function that I suspect matches one of the xlCVError enumerated data type constants...
Further to threads thread770-14670 and Thread770-13682
A rather verbose, but comprehensive user defined function follows, and can be pasted directly from here, into your spreadsheet.
If anyone has bothered to do one for two variables, I would appreciate a copy.
Thanks Bruce Mutton
Option...
Am developing a workbook to perform some engineering analysis and design calculations.
It is linked to a multisheet set of datatables.
Contains about 16 sheets, and these have about 28 embedded charts. A number of the sheets contain vba code pages to iterate to a solution on each calculate...
thread766-11466 contains the full text of my question, however it commences as follows...
Hi all
I have written a simple user defined function to make it apparent on the worksheet when events are no longer being triggered. (I have an iterative solver type routine that is triggered by the...
Hi all
I have written a simple user defined function to make it apparent on the worksheet when events are no longer being triggered. (I have an iterative solver type routine that is triggered by the calculate event, rather than using an on sheet button)
In a worksheet cell, I would enter...
