-
I have a spreadsheet that has begun behaving badly. The behavior: Certain cells are supposed to hold formulas, but upon recalculation, the formula is often replaced with the value of the formula. The affected cells are ones that at one time contained custom functions. Other than that, the behavior seems...
-
Hi there, Firstly apologies if something similar has been answered before, or i've missed something very obvious, i'm by no means a VB expert. Background I have a Worksheet broken down into Sections, at the top of each Section I have a Macro for Users to Show/Hide (the Rows for) that Section...
-
Using Excel 2003, I would like to automate the process of creating a worksheet from a template, got this working, then automate sending this worksheet to a defined distribution list. I tried recording a macro but it stops after the email is called without entering the recipients and then sending the...
-
I use Excel in real estate and personal goal setting and run into questions that aren't evident to me.. like 'how to get around circular formula errors .. pair prior ttl today run ttl pair prior ttl total run ttl A/U 100 10 110 E/U 10 7 17 G/U 50 2 52 N/U 10 8 18 E/G 200 3 203 U/C 10 9 19 E/C...
-
I'm writing what some of us call a 'dictator' application using Excel for a UK Government body to be deployed in the Education Sector. The spreadsheet is a sort of ready reckoner for Performance Measurment. There are the usual corporate technical and political issues in the deployment of...
-
Does anyone have experience in developing a single file in a team environment? I have been working on this file by myself, but we have finally added one more person. I know you can't share a file that has a VBA project. So how do you go about working on the same file? Thanks
-
I am trying to avoid using sendkeys in one of the application. The code is simple and I am just trying to copy page setup from one worksheet to second using a hack. It selects 2 worksheets and activates the worksheet from which I want to copy the page setup and sends the keys to the page setup dialog...
-
I am trying to get to grips with object heirarchy Could someone please let me know why the following work/ don't work (as noted in the comments) before I loose my marbles completely - any insight would be appreciated: Many thanks - Alastair . . Set AppExcel = CreateObject("Excel.Application"...
-
I have looked for hours on the net. I have tried everything from just about 30 sites and I am still not able to create a combobox that works the way I need it to. I have gotten the combobox to be created in a module. The combobox list is where I am having problems. I can place a rutine in the worksheet...
-
Hi Mike, Thank you very much for your reply - which does work in the sernerio I have given. Where the resulting address from =ADDRESS(ROW(Latest2)+MATCH($W$77,Latest2,0),COLUMN(Latest2),4,1) is in c57 - address = k7 and the result of =ADDRESS(ROW(Latest2)+MATCH($W$77,Latest2,0)-1,COLUMN(Latest2),4,1...