General

Count the number of columns on row that are not empty within a ran
I have a very large range, say A3 to AD97. Within this data, there needs to be additional data added weekly. What I want to do is add the data, via a macro, that will add the data on the row and in the last column of data plus 1. lastcoll = Cells(3, Columns.Count).End(xlToLeft).Column this gives me the l... 30 Mar 2010 15:01

Location of Grand Total in Pivot table
Is the a way to show the Grand total next to the selected Field as opposed to the right now column ( I am using a file that had data results by Date)? ... 30 Mar 2010 15:01

can't open Excel file
After a worksheet disappeared, I tried to re-open. Explorer lists the file, but when I open it, the command section at the top is inaccessible and the worksheet does not show up. How do I get to it again? ... 30 Mar 2010 13:54

Syntax Help
OK MAX, Hope this reply is correct enough. And if you would have read what I stated carefully, It didn't seem to work. I did use your suggestion of doing the calcs on the host Worksheet, but I'm still not getting the results I need. I Understand the phrase that you gave before, but I'm not seeing the &rows(... 30 Mar 2010 18:25

How do I multiply the content of a cell by a number
I need to multiply the content of a cell by a number (e.g. 2) but have been receiving the error message saying that there is a circular reference. Is there a way out? ... 30 Mar 2010 13:54

Highlight Five Values With Conditional Formula
Excel 2007 Table, PivotTable, CF http://c0718892.cdn.cloudfiles.rackspacecloud.com/03_30_10.xlsx Pdf preview: http://www.mediafire.com/file/zfw15tj1noz/03_30_10.pdf ... 30 Mar 2010 12:47

Replace #N/A with 0
When I use the vLookup formula and the result is #N/A, I need to replace this with a 0, is this possible in only one formula? Thanks in advance Regards Emece.- ... 30 Mar 2010 12:47

Scroll bar disappears when panes frozen
Hi When I freeze the panes on a spreadsheet the right scroll button on the bottom scroll bar disappears. Also a bunch of vertical lines appear within the scroll bar itself. Any ideas on how to stop this from happening woudl be greatly appreciated. Thank you -- Jay Litchfield AIS Inc. ... 30 Mar 2010 12:47

excel macro/funcion insert row if
I need to insert rows in my excel spreadsheet under certain conditions. Specifically, I should always have six lines with certain data in it. But sometimes I have less. In order to process the data further I then need to insert empty rows. For example, I might have 1456 1234 1456 1345 1789 2479 2567 the... 30 Mar 2010 12:47

Insert a Verisign Digital Certificate
My company uses a program called PureEdge that enables users to click a simple "Sign Here" button and record a digital signature. The signature is time-stamped and used primarily for electronic approvals. We would like to streamline the approval process using Excel, but it is important to retain this approv... 30 Mar 2010 12:47