Hi All,
If I have an array of random un-sorted values, is there a way that I can quickly sort them (i.e., Array().sort)? Is it possible to use this method on a multi-dimentional array by ...
I am using this formula to calculate a prorated rent amount:
=(DATEDIF(C20,C21,"m")*C8)+(C8/(EOMONTH(C20,0)-EOMONTH(C20,-1))*(EOMONTH(C20,0)-C20+1))-(C8/(EOMONTH(C21,0)-EOMONTH(C21,-1))*(EO...
Hi,
I would like to know the maximun size (mb) that an excel file can be.
thanks
I get this error when trying to save or close an excel spreadsheet that gets data from another open spreadsheet.
Excel cannot complete this task with available resou...
Hi Experts
I am using the macro below to format and juggle a sheet including merging 2 cells into 1 on each row.
However, the sheet I am using has x amount of rows and I need to carry ou...
HI,
I want to write a Macro in Excel
Like if in macro I write below code it selects the cells A1 till F1.
Thats fine.
I want to get the value written in column F10. How to get ...
I need to provide information for a database. I have pictures then information relating to that picture (maybe 6 or 7 fields). I tried "Insert -> Picture -> from a file"
It put the pictu...
Here's my class module:
== Original Class Module ==
Option Explicit
Private m_parts(4) As String
When I compile it, I get this error:
"Compile error:
Constants, fixed-lengths, ...
I have to submit this work today, would appreciate any help on this.
This is related to an earlier question I had posted, maybe Kevin or Patrick can help me out with this one. I want...
Hello,
I have a column of data with a trailing whitespace; -- it's not a "normal" space, as I've tried many ways to remove the trailing space. =TRIM does not work-- no luck with =value, or...
I need to calculate the standard deviation for 11 data points (see below). I'm familiar with Excel's formula:
=StDev(cellrange).
Based on data, I'm not sure which column (B or C) I sho...
Hi there
Can anybody give me a piece of code that merge adjective two cells into one?
Using Merge function in Excell wipe away the data of right side of the cell.
I don't want to loose le...
Does anyone know of a way to unprotect an Excel worksheet so that I can edit the fields? My predecessor left me with some complicated reports with protected fields that I must edit but he didn...
I have a workbook with mulitiple worksheets that have queries and the sheets are protected except for selected ranges. I need to update the queries everyday so unprotecting and refreshing each...
What is the Excel version of Word's "normal.dot"?
I need some VBA code to copy worksheet rows of data from columns V to Z to another workbook to two different worksheets depending upon the criteria in column H. The values in the rows on col...
Hi i need a solution or Function which i can use to remove all non numric characters from a cell.
For Example if a cell contains $A16 i want to be left with 16.
Your help is appreciated
...
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...
A customer of mine just sent me an Excel spreadsheet they have been using for a couple of years. They need to change some calculations in various cell formulas. Big problem: the worksheet is p...
Is there a code to center the text in a range of cells. I have a macro that after it is ran the cells are left justified, but the formatting tool bar states that it is centered.
Good Afternoon
Experts:
I have a Workbook with 3 sheets. This workbook is used to track changes made to a system. The first sheet contains a column called "Type". This type is either a ...
Hi experts,
I am creating a macro to display a list of document numbers based on the transaction code selected from a combo box. The list is displayed on the same sheet (Sheet1).
For ea...
Hi, I am working through Microsoft Knowledge Base Article 213772 "How to Use System, User, and File Data Sources"
It describes how to use an Excel VBA Macro to link up (via ODBC) to the MS ...
I have an application that needs to add OptionButtons dynamically. I currently have the following code:
ActiveSheet.OLEObjects.Add(ClassType:="Forms.OptionButton.1", Link:=Fals...
I brought in a text file into my Excel spreadsheet, but I always have blank lines in between records. My spreadsheet is a few thousand records long. Is there an easy way to remove the blank li...
