In this code, I do not see any difference between cell.value and cells.formula when it comes to entering a formula.
They both did the same thing. Am I right? Is there any case, I have to use cells.formula instead of cells.value? Thank you very much.
Hoping someone might have some thoughts on optimizing the code below. I am inserting
5 rows each time a new employee is found. Then adding the text for the pay category.
I have done some research and was wondering if "Resize" may be a viable option.
X = 2
Do Until Cells(X...
I am using the code below to search cells for certain criteria and then keeping certain
rows and deleting certain rows.
This code currently takes around 1 hour to process 95,000 records. I need help in
determining if there is a better way.
'Delete Level 1's and certain Level 2's
I've received and modified a simple VBA from another excel and i was wondering if anyone could help me modify even more. The thing i need is that the range of this code would be across all documents worksheets.
I1,I2,I3 stays in the first sheet. Date and Name in any other if I2 or I3...
Hope you are having a great week.
I am trying to figure out a way to calculate AHT (Average Handling time) for each cases irrespective of the dates. Just to summarize the table, DE stands for Data Entry. Average handling time is calculated as the total time taken to complete a...
I have a search option on my Userform enabling the user to search via Client or Opportunity name, and use the below code to find the result and populate various text/comboboxes on the search form. This enables the user to check it is the correct record before selecting it...
I'm using this really cool function in 32 bit Excel.
It says I should not alter it.. but even if I try by just adding ptrsafe I can't get it to work.
Is there a another similar routine I could use in 64 bit environment?
Any help appreciated. Here is the full function.
'This code was...
The code is shown below.
I have a userform with Comboboxes
ComboBox1 is MONTH
ComboBox2 is YEAR
Month is to be inserted into cell A3
Year is to be inserted into cell C3
When i press my transfer button the YEAR isnt shown on the worksheet but the MONTH is entered into cell A3
It is possible to have a formula where i can add a sum to a product? And in my particular case, is it possible that the result of the cell have the sum of a value just only if there are particular conditions?
I placed this formula in order to have the result of...
One more help needed. In one column i have multiple email addresses of different length. For eg: firstname.lastname@example.org. How can i extract value after "@" and before "." which in this case is "rediffmail" ??
I have a user that logs into OneStream and gets all his data in Excel but he has several files, but I need to refresh all these files through a macro. The problem is how to I do this?
I tried the following macro but it doesn't work:
For Each cnct In ThisWorkbook.Connections
I hope that you can help me in this.
I have 2 sheets, using a list of data in the other sheet to enter the data into the first sheet, I’ve used a VBA code to get a searchable list with a combobox, what I need is to get the value removed from the data validation list if used before to...
I developed a spreadsheet that when the file is opened it sends an e-mail after 1 minute and then it auto close the workbook.
Application.OnTime Now + TimeValue("00:01:00"), "SendReport"
There are certain days that I need to send the report. So I created a task scheduled on Windows to send...
Is there a way to add only a range of cells instead of entire row? Here, I will like to insert from Col B to Col O. I have other data adjacent the range B:O and the entire row is interfering with the layout. I will be more than happy to find a work around. Thanks in advance...
I have a drop down box on a sheet called Start_here with 2 options and each option is a town. When the option is selected and a Continue button is pressed I need a header and footer to be loaded onto the sheet quote_sheet depending on the town selected.
The headers and footers are images...
I have my userform almost done. I am able to do my searches, a it sorts the data properly. It will show first match in my form, but have added Prev and Next Buttons to look through similar matches. I am not sure how to get it to work with the search results.
Here is a screen shot...
Please could you check my code & advise a fix.
I open my workbook.
It defaults to INCOME (1) to open first.
I see the msgbox asking me to select MONTH & YEAR
I choose to select CLOSE FORM
The form quickly coses then reopens.
I choose to select CLOSE FORM again & it closes.
Now i can do...
I have a table with multiple columns and a form that adds data to each of those columns, as a "case". I also have a separate function that adds data to some of those columns, based on the value in column A as a "case update". How do i get the remaining blank cells in that row to fill with...
I have the following piece of VBA code that ensures if a name is entered in column 14 then then it makes sure its proper case or changes it. However when you paste in more then one line in to column 14 i get the error: Run-Time Error '13' Type Mismatch. Can anyone think how to stop this...