First  |  Prev |  Next  |  Last
Pages: 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223
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 Pdf preview: ... 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
First  |  Prev |  Next  |  Last
Pages: 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223