I have this line of code and get the error message"Object Variable or with Block Variable not Set" what have I done incorrectly.
Set NewRng = Range(rgToUse, rgToUse.End(xlToRight)) 'Comment...
Need to get distinct values sorted alphabetically from column using formula
e.g.:- I need to have values such as below in one of my excel column.
Item 2
Item 1
Item 2
Item 1
Item 2
Item...
Hi,
I'm trying to work out the Compound Annual Growth Rate of company PROFITs.
The standard CAGR equation is:
=((end / start) ^ (1 / years) - 1)
That's fine where 'end' and 'start' are...
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...
How can I convert hh:mm:ss to decimal hours for applying labor rate? I'd need to go to four decimal places for accuracy. For instance, a typical labor entry from my database indicates start ti...
I need an Excel formula that calculates interest on several different loan amounts on a daily basis ongoing. For example, one loan is in the amount of $12,400 and occurred 4/30/03. It is to ...
I am using the End xldown command to activate a range. I first search for text in a cell, the header, and then offset down one row to get to the first cell in the range I want to activate. M...
Hi,
I have an excel spreadsheet that I am attempting to import into Access.
The problem is it wont import due to Excel interperating a carriage return (new line) as a square.
If I use t...
Team,
I have 6 SUB procedures and to run all the 6 SUB procedures is taking me a while to run. I need a progress bar which displays the name of the current module the file is running and ho...
This is horrible if it's by design, so please let me know if there is a fix or if this is also what others are experiencing:
An Excel 2007 xlsx file is created. An Excel 2003 user, with th...
I have a notepad that I want to convert into excel. The notepad is structured in this way,
Page 1
Field Description Pos ...
I have two excel spreadsheets. One is a list of customers with their names and addresses and id numbers (unique for each customer). The other is a list of items the customer bought with ea...
How do I implement the following logic in VBA:
If Cell A1 >= Cell A2 Then
Change Color Of Cell A1 To Red
Change Color Of Cell A1 To Red
End If
- I want this triggered by num...
I need help to modify my Excel formula. This is what I want my formula to do:
1. If F16 and E16 is empty, G16 = " "
2. If F16 > E16, G16 = "F16 is bigger"
3. If F16 < E16, G16 = "E16 is big...
I am looking for a VBA that will find the first empty cell in a column and copy the cell directly above it and then go on to the next and do the same until the end of the spreadsheet.
Ideal...
Can anyone please send me a VB macro for EXCEL for changing EXCEL cell into graphics pattern based on some string value, for example, "M"?
I would also need a macro to count the number of c...
I don't have a good experience in Excel program so I want to put a date like dd-mm-yyyy in a cell like
1-Jan-2005 and in other cell 5-jan-2008 then I need to subtract two from one to get res...
Hi,
I have an Excel Chart in an Excel Worksheet. I have added a Scrollbar control using View->Toolbars->Forms and selecting the scrollbar control. Is there any way wherein I can access the ...
I have a large text file that i use vba to format. I would like to be able to count all duplicates on the 2nd row and then delete both the 2nd and 1st rows leaving only the first occurence wit...
What is the maximum number of worksheets in an MS Excel Workbook?
I am interested in programatically selecting an entire row in Excel, so that it is clear that it is selected. It is important that when a user types to edit, the originally clicked cell is the...
Team,
I have currently built a report for senior management by which information from Excels workbook is copied to MS Office using VBA. The whole report works except for this ridiculous mil...
Hi
I have a locked spreadsheet and i want to be able run a macro from a button to do the following:
1. Unlock the sheet
2. Ask user for a populated cell which they want to attach a hype...
There is one user who accesses excel spreadsheets via a network share who often gets error message: "filename.xls is locked for editing by the username(its the user themselves) click to notify...
In Excel. I'm trying to perform two calculations.
The first calculation is the difference between two times: start time and end time. This column is in the datetime formatting and list...
