Search results for query: *

I am trying to hide/unhide some table elements. Namely, if the value in a Select element is true, then show the table element and based on the value of the select element, unhide "x" number of table cells that were originally hidden. My current problem is that the table is visible before I...

Vragabond, Thanks. Didn't read your original post close enough. Works well.

Please take a look at this page: http://www.childrenschoirofburlington.ca/npis/ztest.cfm in a Mozilla browser like FireFox. On there I have an image of a question mark. I want it to be bottom aligned with the text "Edit Customer". But for some reason it is top aligned or there is some extra...

I have checked the ThisWorkbook sheet in the VBA module. No reference to Workbook_SheetCalculate or the Worksheet_Calculate events. I have abandonned trying to fix this one. My workaround is to leave the worksheet Unprotected. Thanks for your input.

The macro inserts some records in another worksheet. There are no references in my macros between worksheets. That is to say, none of the macros call other worksheets, with the exception of the close workbook macro [Private Sub Workbook_BeforeClose(Cancel As Boolean)], where I'm simply hiding...

spreadsheet means another workbook. The workbook I provided for download is a copy of one of the worksheets in the original workbook. this behaviour of invoking a macro from a different worksheet from the original workbook only exhibits itself in Excel 97. Would you happen to have a copy of...

I've created a spreadsheet with several sheets each with their own set of macros. On one of the sheets, I have a weird situation. When I hover the mouse of the cells in the range of Z6:AE29, my mouse pointer is showing the pointing finger as if there is a button under it. When I click it, it...

Skip, I cannot do that. Because I need to calculate based on the sum of the values and whether the sum is positive or negative. Not the individual numbers. For instance see below. I have two groups of raw data. If I perform my positive/negative calculation in the source data, I get...

I made an error in my pivot data above. There is only one instance of Sun and one instance of Mon per normal pivot table grouping function. Therefore, I cannot base a SUMIF formula on that column. This is the trouble I'm having with just using a Worksheet formula.

Has anyone every had to create a column adjacent to a pivottable and then tried to create sub-totals and grand-total for that manual column? I'm having a hell of a time trying to figure this one out either with an Excel worksheet formula or via VBA. I had to create a new column adjacent to my...

I have a big problem. I need to vertically align an image and clip it at the same time. My images are randomly different sizes each time the user refreshes the screen, hence the need to "clip" them. But the problem is the the vertical alignment code that I have found on the boards doesn't...

Found Solution. Bad coding on my part. I had no need for a span tag, since I can apply formatting to the TD tag. All works well now.

Correction. The tag is a SPAN tag. And it is inside a TD tag.

I'm adding a border around a div tag. The div tag is a specified width. In IE the border works fine, that is, it wraps around the full 150px width. But in FF the border wraps around the text, making it variable. Why is this? Here is my CSS code. .collectionsmenu2 { width:150px...

See example at www.digiuseppe.ca/files/pivottableexample.xls

Nice thought. However, that won't work, because the negative number is based on the sum of the gross margin and not the gross margin of the individual rows in the source date. I would get a different answer if I did an IF statement on the raw data than on the sum of the raw data. Are you...

I have a pivot table with a column of positive and negative values. I want to create a calculated field to sum up the positive values only. However, when I do that, the subtotals are not taking the If statement of the calculated field into account and is simply summing up the field to the left...

Thanks Skip.

Here is the code I am currently using to enter an array formula into the activecell in a worksheet. ActiveCell.FormulaArray = "=INDEX(GamesList,SMALL(IF(GamesList=SelectedSessionIndex,ROW(GamesList)-ROW(GamesListFirstPosition),ROW(GamesListLastPosition)),5),9)" What I would like to do is...

I am using an array formula to find a value, but I want to enter the resulting value of the array and not the array formula itself. Right now I am using ActiveCell.FormulaArray = "array formula...". But what I really want is to enter the value of that array formula.