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...
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 ...
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 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...
After I jump via hyperlink to a particular cell, I would like that cell to be scolled to the top of the viewable window
Any way to do this?
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)
...
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...
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...
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...
We have a need to create a somewhat automated process for detecting changes between two excel spreadsheets. Column A of each spreadsheet contains a unique reference number for the row, and we...
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...
I have an excel spreadsheet that has a lot of custom macros.. when selecting a bunch of cells and copying them, Excel freezes and hangs completely.. has to be killed and restarted..
It happ...
Hi
i would like call Macro and use Userform that specific partnumber and specific date range calculate the average.
Thanks,
I have a spreadsheet that has roughly 6000 rows in it. Each row contains a column with start date/time and end date/time. These rows represent phone calls, their start time and end time. I ...
I have noticed that when I protect a worksheet so hidden columns cannot be opened, that users cannot use the SUM feature in other columns. Is there a way around this? Can I protect the sheet...
Greetings all
I have a spreadsheet that contains several worksheets. Sheet 1 contains a list of students (student no, name, email, etc). Sheet 2 contains a list of class attendances (stude...
Hello Experts. I need a macro to hide all the columns in a table except the column that is selected in cell B5.
Thanks.
I have a timer event in an addin which determines at mid-day if a workbook is open or closed...if it is open it prints out a range......if it is closed it opens the workbook and prints out a r...
Using Excel 2003, selecting FILE, SAVE AS, and then clicking the down triangle next to "LOOK IN" tha application locks. If I look in task manager, it shows two instances of excel running. This...
Greetings Experts!
I have a spreadsheet that I use for my homeowner's association. There is a column that represents how much the homeowner has paid for a particular year. For the ones th...
folks
how do i convert 72 minutes /1 hours and 12 minutes to hundreds ie 1,2?
all help will do
r
I would like to use autofit because my user might enter longer text that can take 2 or 3 rows. I just don't like how close the gridlines get to the text. I would like to have autofit +1 or +...
hey folks.. hoping someone could help.
i have a spreadsheet that has roughyl 6500 rows and 31 columns. this is all pertinent customer data
in row 1 is the file #, row 2 is the location, r...
