Hi
What is the VBA Code to remove Cells, Rows, Worksheet under Format when opening a workbook, and re-instating it when closing a workbook.
Thanks
Greg
I'm working with latitude/longitide values in Excel, and the volume of data changes from day-to-day. Consider the data below:
A B
1 40.02 120.03
2 40.02 119.05
3 40...
Hi All
Is it possible for me to combine 2 sheets together after filtering. OK! Let says I got a sheet A and sheetA_continuation. Is it possible for me to combine both sheets after filtering...
I have a combo box on a UserForm and the Column Count is set to 2 with the RowSource Sheet1!A2:B100.
When I click the down arrow I see both columns and my selection is bound to Column1.
Is i...
I have multiple spreadsheets that I have written a macro to format on a monthly basis. I would also like to add a step that saves them as a text file and changes the file name based on a cert...
I have many rows and columns that have cell references.
I want to batch change all the cell references from being like:-
=A1 to =$A$1
so that I can sort the rows without the informati...
I have a macro that extracts data from an Excel sheet and into a Word ducument table. It was working fine until I removed serveral rows from the spreadsheet, now it complaints about the follow...
I have two lists as follows:
Column A Column B
B1 - Craig Manchester - 7.4375 7.4375
B1 - Larry Lessor - 8.0833 8.0833
B1 - Rich Rottle - 7.375 7.3750
B1 - Glen Tamura - 8...
I have created trendlines in Excel 2007 from monthly sales figures (actuals) for the previous financial year. I now want to add 17% to that trendline, and make this the target sales figures fo...
Hi All
In excel i want to change all the values in a range to "No". I tried the code below but it does not seem to work.
Hi All
I'm using Excel 2007. I still have problems to synchronize a filter in a pivot table with one in a worksheet. I have two .xls worksheets both with data on a sheet and a pivot table on ...
I have several listboxes on a userform. These are normally not visible. I wish to make some of the listboxes visible based on a variable number. How do I refer to a listbox using a variable...
i have several sheets and the possibility of more
each sheet has names and ss# for identification - names could be the same - unique id is ss#
the worksheets also show weekly totals and dues...
I would like a macro that will delete all rows after row 310 that have data in them.
Please advise.
I need to use a value from Sheet2, G19 which generated from other information write this value as part of a new record entyr in Sheet3. I can write the record to sheet3 but I can't get the cod...
I have a worksheet that I need to export to txt, but I'd like to prompt the user for the save location (using the save as window). How do I do that using VBA?
Thanks.
Assume the cursor is in cell K80
How to toggle the highlight on/off for the entire row left to right using the keyboard only ?
Experts,
I have a pivot table that displays a persons ID number, there name and then breaks down their performance numbers into three categories. What I want to do is use a VLOOKUP based o...
I have a column about 500 cells long with positive and negative numbers in each cell. I would like to query the column to see what combination of numbers = the number I have.
It should d...
How would I go about creating a list in column A of weekdays between January 2004 and December 2010 skipping weekends.
EX
1/1/2004
1/2/2004
1/5/2004
.
.
.
12/31/2010
Hi EE,
I´m trying to make some simple arithmetic operations on an imported set of data, but it happens that something is wrong. Please refer to attached file, range B193:B196. Correct data ...
Hi experts:
In VBA, how do I clear content of all rows but row#1 on a worksheet?
Thanks.
Experts:
I've written the below code in Excel VBA which seems to work fine with one catch: After the fifth iteration the script stops running. I have seven iterations (see attached file)....
Hi,
I refer to :
http://support.microsoft.com/?kbid=245104
Attached is an Excel spreadsheet which a Helpdesk staff has sent to me
& she's able to get the AgeFunc to work on her PC.
...
I have a macro which shows a chart in print preview.
However I would like to add the title in to this view which changes depending on your selection. Therefore I would prefer it to stay in...
