I have a data table that is autofiltered. With filters in place, I would like to paste something to a range that will only change the visible, filtered values. It is currently pasting to even...
Excel, VBA:
I have in fact three challenges:
1) I wish to copy a cell from one sheet to another if a criteria (set out in a different cell) is met.
In sheet 1 column C:C lists the ...
Hi All,
I am copying Excel Sheets from one workbook to another workbook. The process is taking long time so i want to add a progress bar to cover up the time.How to increment the progress bar...
Hi:
I have been reading the forums here and have not been able to figure out how to convert and XLS file to CSV format.
The file is located in:
C:\Automated CFP Reporting\mail
The fi...
Hi,
in one of my workbooks I have a function TABLE() . It is actually inside an array formula. But I cannot find this function in the help.
Anyone know what it is?
Using Excel 2002.
Have opened an excel spreadsheet that has on each page as a watermark in the centre of the page, "page 1", "page 2", "page 3" etc, that doesn't apear on Print preview or whe...
I have written the following vba macro to save a particular worksheet as a separate workbook.
Private Sub ExportRptCommandButton_Click()
Dim fName As String, FileNm As String
'GET THE...
Hi, is it possible to have Combo Boxes in cells in Excel? If so how? (I commonly program in MS Access, but not much experience in Excel.)
how to find distinct row in excel
I have A:1 to A:158 cells and they have values like
aa
bb
bb
cc
cd
aa
sp
I want to get only distinct values. How can I do that?
I am looking for a way to print things directly to Excel. Our ERP system creates reports that we can print, but I need them in Excel. A program called Print2Excel (www.print2excel.com) works...
I need some code to remove any spaces in a string. I have a list of accounts in a column A and each cell has a bunch of numbers in it.
Example
Cell A1 100 00 0000 00
Cell A2 2222 2 22...
Hi, I need to know how many working days have gone through specific dates but do not include Saturday or Sunday, for example for July 2005:
A1 Beginning Date
A2 Todays Date
Answer for...
Is there a way to convert a string to an integer using VBA? I have written some nested If's inside of a loop in order to find the next available extension to use while creating a work breakdo...
I am trying to write the vb code to clear any and all excel applications which may be running on the PC.
I have the following but keep getting an error when it goes to close out the second a...
Experts:
Is there a date difference function that returns the number of years, months, and days? I've been searching for a long time for something that would give me the correct answer.
...
I have this line of code and get the error message"Object Variable or with Block Variable not Set" what have I done incorrectly.
Set NewRng = Range(rgToUse, rgToUse.End(xlToRight)) 'Comment...
My Excel file couldn't be saved. When I press 'save', it will pop up an error message:"Document Not Saved". My other Excel files are ok.
I would like to know how to embed an images (jpg) into cells in Excel 2000. Each row will need to have a different product image embeded. I don't want to do Insert>picture>from file, since usi...
Hi,
If I have two numbers (in dollars):
2005 Spend 2004 Spend
5000 2500
and I want to find what the percentage increase from 2004 to 2005 was, how do I ...
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,
Excel file too large takes long time to open,save etc.Can all the macros be saved some where and i should be able to run them when required.
Can i have all macros in some folder.When r...
I am writing an Excel macro to save a file as *.xml. I need to keep the SaveAs path relative because my clients may store these files anywhere on a shared drive or web server. I am not sure of...
I have a client who has requested an Excel.xls file to be password protected when opened. This file contains confidential information so when the user attempts to open the file they would like...
I have an excel document where column F shows the delivered weight and column G shows the used weight. I can calculate the percentage used by using the following formula
=SUM(G4/F4)*100
So i...
A couple of users are getting the error "Not enough system resources to display completely" in Excel. One user only gets it when they have a lot of excel documents open, these documents have m...
