Hi,
I trying to copy 5 cells into one cell with macro in excel 2003. I have an memberlist with adresses in rows and want into one cell in another sheet, but I can't get it right. The result ...
Excel 2003:
I'am using the following to determine a used range..
But it does not always return the correct range..
The row determinination is not always correct < ------------------
...
I have two cells I would like to concatenate, with them divided by a carriage return
eg
A1 abc
B1 def
to appear in the next cell as
abc
def
I have tried
=A1 & chr(10) & ...
Experts,
I am working on some code to extract certain values from an Excel model. I receive this model on a regular basis. There are no named ranges and sometimes rows are added, so direc...
I have to repeatly paste special values from one work book to another. Is there a way to create a hot key that will do just paste special value?
Hello Experts. Epclm designed the subs in the file below and I would like to add an inputbox. I would like the input box to popup when the cell J9 on sheet data is selected and provide a war...
Hi. I've done a lot of Access work but am not very familiar with Excel beyond the basics and forget about Excel programming. I have a user that imports data into a spreadsheet each month and...
HI everyone,
I'm tring to solve a problem and I will need your help.
I have a 2 sheet exel workbook, one of them is Main Menu, and the other one is Tables.
I want to put a button on the m...
Hello in Excel 2007, I have alway the same calculation error in the Excel sheets.
Here is an example: Open up an excel sheet, and insert 200 in cell C1 and 200.01 in cell C2.
Then run th...
A B C D
Selling Price Cost Price MarkUp % Discount %
18000 18000
27900 27900
What would the formula be in A1, A2.......An if I wa...
Hello,
I am trying to get 1 shape appear from 3 different shapes choices based upon the value of 1 cell.
So, using this formula on sheet 1
=IF(E15<0.85, " Under Efficiency", IF(AND(E15>...
Hello Experts. I need help on a macro to automatically copy and past a range from 1 sheet to another. The "copy" buton is on sheet "Aug 08" and the data is on sheet "Data". The macro that I...
Hi,
Excel script that can move files from one folder to another as per path. Attached a sample file
Row 2 will have the Folder paths where the below files has to be moved.
So data below...
I have VBA code that copies a block of cells and does a PasteSpecial to another worksheet. Unfortunately, the formulas are getting altered in the process. For example a cell with the followi...
Hi,
How can i get images in a folder to small sizes and place them in an excel file in the cells.And when clicked the image opens the big file.
Say i select a folder put its name and run...
Hi
In Excel VBA is it possible to change he colour of the selected row of a ListBox
Thanks
I have a worksheet that has 6 group with 14 data lines in each and 7 months of data for each group. I want to create via VBA a a total group and then then summary of the 14 data lines and eac...
I have a sheet in an Excel 2007 workbook called Cars. It tracks any work done to any of the vehicles I own.
Column A - Date of Service
Column B - Vehicle Serviced (Corolla, Camry or Tacoma)
...
I am developing a user-defined function (UDF) that needs to switch between six possible named ranges:
GROUP A
"Bids_A" (on worksheet "Bids-A")
"Bids_A_GID" (on worksheet "Bids-A")
"Bids_...
I have a client who opened a Excel attachment from Outlook, then spent 8 hours updating it - and kept saving it, but not "Saving As" to the right location. It is now gone, and it does not app...
I am using VBA to copy from another application and paste into Excel.
'Sometimes' I get an error message that "Paste Special method of Range class failed"
This works over 90% of the tim...
What is the formula to find out how much you would make if you were to deposit X amount of dollars every year, at X interest rate, ... Please see attachment.
It does not add the interest ra...
I would like to be able to have a running total in my Excel Pivot table and then create a calculated field off of that running total. This is a recurring issue that I normally fix in the bac...
Hi there guys. I'm sorry i cannot attach an example to show you what i'm working with, but its fairly simple. Heres a rough idea of how it looks:
A1 B1 C1 D1 ...
Hi:
I use the following code to hide a worksheet, but after that I found the worksheet cannot be deleted and I cannot unhide it manually by doing Format->Sheet->unhide. Please help.
Act...
