Hi,
I have added the following formula in a pivot table to calculate growth rate in Year2 from Year1. I want the formula to return blank or N/A if the result is an error. However, my form...
I have an excel document i had each sheet protected with a password, I have been succefully locking and unlock the sheet to make changes. However the last time I decide to share the workbook. ...
Dim lastrow1 As Long
lastrow1 = ws1.Range("A65536").End(xlUp).Row
In ("A5:A" & lastrow1), I want to conunt cells if
.Interior.ColorIndex = 34 'light blue
.Interior.ColorIndex = ...
I am using conditional formatting to set the cell colour based on cell value. Conditions are: =0, between 0.01 and 0.09, else I want the existing cell colour left as is. This works fine for ...
On sheet1, I have three columns (Last Name, First Name and Unique ID).
On Sheet2, I have the same columns.
Sample Data:
Deer John 000000001
Doe Jane 000000002
Clooney George...
Hi!
I have a problem with special function 'PasteValues' are assigned to my regular paste functionality in Excel. It all works perfect as long as I stay in the same workbook but if I copy a v...
In Excel
I have the following formula in a cell...
=IF(C5="","",(D4+B5-C5))
The basic idea is if cell C in a row is empty, then cell D will be empty also, otherwise it will fill in the form...
I brought in a text file into my Excel spreadsheet, but I always have blank lines in between records. My spreadsheet is a few thousand records long. Is there an easy way to remove the blank li...
A shared file has been opened by network user 'A' but she has received an error message stating that the file is locked for editing by network user 'B', however 'B' had finished using it, sav...
Hi, I am working through Microsoft Knowledge Base Article 213772 "How to Use System, User, and File Data Sources"
It describes how to use an Excel VBA Macro to link up (via ODBC) to the MS ...
Hi - I'm creating a Excel pivot table from a Query in an Access database. I need it to count the number of products reviewed in a specific week, but the dataset has the review as the primary k...
I have a very simple code to hide and unhide worksheets when user disable/enable macro. However when I protect the workbook, the hide/unhide cannot work. Is it possible to protect the workbook...
Hi all,
When I start Microsoft Excel XP i'm getting this error:
"Compilation error in hidden module: ThisWorkBook"
How can i fix it?
Dear Sir,
Am using Microsoft Office SR-1 Professional on Microsoft XP Pro.
Am unable to open any excel file by double click. I have to first open excel and then open the file.
I t was w...
Hi guys
I have a XLA file that someone else created that i want to edit to chaneg some stuff.
How do i go about editing the XLA file?
Need to get distinct values sorted alphabetically from column using formula
e.g.:- I need to have values such as below in one of my excel column.
Item 2
Item 1
Item 2
Item 1
Item 2
Item...
I just need some free excel invoice templates, basic ones, nothing special, black & white.
Thanx
I need an Excel formula that calculates interest on several different loan amounts on a daily basis ongoing. For example, one loan is in the amount of $12,400 and occurred 4/30/03. It is to ...
Looking for some good links to understand vba scripting dictionary and/or some examples
I am importing financial data into a database with a file that is in .csv format. Currently, I have to open the .csv file that I converted from .xls in Notepad and then use the Find / Replace ...
I have in Module1(Code):
Public MyVariable as Boolean
and code (Sub Foo) looking at the variable.
In Sheet1(Code), I have:
MyVariable = True
Call Foo
However, just before calli...
I am using VBA in Excel 2007 to populate with data and print around 500 reports which contain column charts. The problem I'm having is that while some longer horizontal axis category labels (...
Hello,
I would like to clear the value from some cells from my range but not the formulas.
This is what I am using:
Range("A2:U1000").ClearContents
However, this deletes the form...
I know in Exel 2003 you can switch worksheets with with CTRL+TAB shortcut. I have found in Excel 2007 that this is not a shortcut.
Has the shortcut changed or is my version of Excel just ac...
I'm trying to use VBA to select multiple rows of data based on certain conditions being met in the cells in those rows. I then want to have VBA automatically select those rows and paste them i...
