I have a range of cells named "RANGE" (original huh ?). I would like to detect each time a row or column is inserted so I can modify my range accordingly. At the same time I would also specify...
Hello -
I was looking through some solutions to try to adapt to my situation. This code (which works really well) was written to open similarly named workbooks ("Book1, Book2, etc.) and co...
I am not able to convert a number greater than 24 into h:m:s
I use the formula =(H5/24;"hh:mm:ss") but this only works up to 24.
When I try this with 27.50, the result is 03:30:00 because ...
I am consistently getting a "Cannot empty clipboard" error in Excel 2007 after a drag and drop. Copy and paste does not produce the error. The same error ocurs using Excel 2007 on both my Vi...
I'd like the followong functionality...
Does anyone know about such a function?
Or is there a built in function?
...or is there a workaround that's better?
The usage is dynamic ran...
Hi Experts,
I'm running into an error for a simple copy / paste code snippet. The user inputs a sort order (could be for a variable number of rows), puts the cursor somewhere in the sort o...
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...
Hi:
Is there an easy way to convert month names, say 'Jan', to 1 and 'Dec' to 12?
On a worksheet I have a ComboBox where users could chose a month and then a cell where users could key ...
Using a macro\VBA want to read the color of a range of conditional cells and change some referenced objects to the same color. I have shapes of states and want to change the color based on th...
I have a spreadsheet which has a DateReq column.
When I click in a cell in that column, I want a calendar to pop up, and when I've selected the date, I want it to populate that cell (and th...
I'm sitting in cell A1. Cell B1 has a date and Cell C1, C2, C3, C4 all contain different dates. I want to say the following
if B1 is between C1 and C2, cell A1 will be red
if B1 is betwe...
Hi,
I'm trying to create a dynamic drop down list in excel.
I have a column of data and I want to make a drop down list from source criteria listed on a separate sheet.
How do I do this...
Hello,
I have cells that have data like this:
37:13:00
but I if I highlight the cell in the top bar in excel it shows the cell's contents as this:
1/1/1900 1:13:00 PM
if I copy and past...
My Excel 2003 VBA Macros need to support both Outlook and Lotus Notes. Lotus Notes is new to me so I am experiencing a couple of problems.
Couple of Problems:
1) When remotely opening Lotu...
I have one user who is having slowness when opening excel files both from the network and locally.
The users computer is as follows Latitude D620 dual processors at 1.8ghz, 1gb ram, Windows...
I have a range of cells in and Excel 2007 workbook. I would like to use a drop-down list to select from the range but have the ability to edit the value once selected. For example, I may sel...
Hi:
I'm running into sum inconsistencies/issues when attempting to programatically a cell format.
I would like to set a cell to be of type "text"
(I need to do this for various reasons ...
I need a code that reads cells in the range A1:D10. The code should read all the cells in one row before jumping to the next.
Requirements:
- If there is value in the first column (A) of a ...
Hi everyone. I'm new to VBA and was wondering why I'm receiving and error message on the 2nd range I want to copy to a new worksheet.
Every week I get a file with trade details, it's abou...
When I convert an XLS to CSV, lots of special characters are converted to ?. I think that the new CSV file is not saved in the UTF8 format, despite the XLS file containing all needed special c...
I know this is a simple question, however I am new to VBA and cannot seem to get this to work. All I need is code to multiply every value in Range "target" by 1000. Thanks in advance for any...
Hello,
I need to create a button that
-has the label "Hide columns" on initial state.
-on first click: hide columns: G,H,I, K,L, M, O,P, Q and switch to show text "Show columns" to sho...
Hi experts:
Thanks for the help with my previous question. The following code works when the user changes certain cell (in this case, B23). However, it doesn't work if the cell changes beca...
I have a series of userforms that allow the user to manipulate and run analysis on their workbook. They are shown modeless in order to allow the user to access the data while the form is open...
