Hi.
How do I do this?
if object_exists(activeworkbook.sheets('A sheet name which may or may not exist')) then
' sheet exists
else
' sheet does not exist
end if
I know I can iter...
Hello,
I have an Excel spreadsheet that I need to convert into an ASCII text file where each column needs to be set at a specific width (column A is position 1-4, column B is position 5-6, co...
Hi
I am trying to count the distinct occurances of a variable (in this case a date) from a colum in excel.
I have a data string in column A consisting of dates (1st - 31st May) but they ...
We use office 2000 and 2003. I would like to know how to have excel open in a new window. Right now I open by clicking on an icon. If I open another excel file it opens in the same window. I w...
Hi experts,
I'm trying to export data from a Excel sheet to a CSV format. I'm using the "save as type CSV" menu option. The output I'm getting is delimited fields by semicolon (";"), instea...
Hi Experts
I have the code below to hyperlink to A1 in another sheet based on a cell value in the original sheet.
How can adjust the code to link to
Range("F65536").End(xlUp) rather than...
Last week Charlotte found that she was no longer able to save a shared Excel spreadsheet which was about 6MB in size. It just said "Document not saved". Sometimes it says that the disk is fu...
I have some data on an Excel Spreadsheet that is cut and pasted from another app:
1. a cell with the year as a string, for example "2004"
2. a cell with a Month as string, for example "Jun...
I've tried everything to open this file ( I do know the password that was on it) It was on my backup hard drive and I did a reinstall of windows. Now I cant get it open.
Thanks for your he...
This project is very urgent, so I would appreciate it if some of you experts out there can figure it out quickly, thanks!
I would like to create a control button that would have the simila...
I have a button on a form that runs a query with a date on the form being used as criteria in the query. I also have an Excel Woorkbook containing a sheet that is linked to the query, and a p...
Hi All-
I have a small vba script that opens and closes a workbook behind the scenes. I need to let the workbook stay open for a few seconds at most to allow for another workbook to update...
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
Cell A1 has text " **1.0 " I want to use this regular expression \*\*\d.\d to remove the **1.0 is there a function that will allow me to do that.
Something like =removematch(A1,\*\*...
What is the easiest way to change a color of a cell based on it's contents? Can this be done with a formula?
For instance something like this pseudocode:
If A1 contains 20.1 then
cha...
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.)
I have column1 with a list of values
I need column2 to give me the following:
if column1 between 0-30, then column2=1
if column1 between 30-60, then column2=2
if column1 between 60-90, ...
A user in our office is analyzing a large set of data with MS Excel. When graphing the data, the user applies a 6th order polynomial trendline. The trendline has this equation:
y = -1E-12...
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...
hi everyone,
I have excel sheet which i use for sales receords, all i wanna know is, IS there anyway to lock the cell formating but still allow people to input data?
so they cant change ...
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...
I have a spreadsheet that contains thousands of items.
I am looking to extract all characters until the first colon (:) from RIGHT SIDE only.
COMPAYRNDED:EXANATION:LAEX:PLUSBOB:GL34X ...
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...
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...
Hi Experts - I have an Excel file using the Special Formatting code for ZIP Codes that allows for leading zero's in this field. However, when it is saved as a csv file (necessary for import t...
