How do I get the last row in a column ?
the code snippet i've included doesnt seem to work (it get the lastrow for the whole sheet and not for a specified range/column.
I saw this somewh...
I need to go line by line, checking the cell one column to the left, to see if it contains specific text strings. If so, then mark the activecell with an "a".
Text strings include "*open*" o...
Hi, im having a problem with a section of code I am writing in VBA to extract some information from an external database.
The below code works fine but this is the only thing i have managed...
O Geniuses, I call upon your wisdom
I have a workbook that uses several data entry cells on different sheets. Several cells use Data Validation to streamline the data entry process. I am go...
Hi Experts
I have two columns in a spreadsheet Column D: Old MSRP and Column I: New MSRP.
I need to create a formula for the percentage of price increase or decrease in Column J:
The ou...
HI Experts,
I am working on a new project which requires a lot of conditinal formatting. From a recent question i have been using the following conditional formatting formulas:
condition 1...
I've added the Mail Recipient (as Attachment) button to my File Menu, but it is always disabled. The option is always enabled for me on another computer with Excel 2002. I use Mozilla Thunde...
A1 = number or text, B1 = number, C1 = A1*B1
If i type a text value in A1 i receive '#VALUE!' in C1
Is there an IF formula or formatting to avoid this error when text is typed in A1? Mo...
In column A1:A500 I have a formulas in each cell. I want to change the relative cell reference for one component in each cell in the column. I cannot use a simple EDIT--->REPLACE ALL to do t...
Hello,
I would like to create a very simple macro to go through each cell in a given column and convert the UK date to US format - it must change the actual cell content (not the format) be...
I really like Excel's GROWTH function, which works pretty well for extrapolating/forecasting out a trend that increases exponentially (the slope increases as you move along the X-axis). But I...
I need a formula that will calculate the overtime hours for a two week pay period. It must only calculate hours over 40 from each given week and sum them.
Hi All,
Can any one quickly suggest me a way to copy anentire worksheet & paste it in naother workbook without changing anything. A quick reply would be v muc helpful
Regards,
Rohit
Hi,
I have an excel spreadsheet with the names and addresses in the columns.
How can i print these and the company logo onto envelopes together?
Can this be done using excel?
thank...
Hello Experts -
I have data on a single column that I need to separate out into multiple columns.
For example..
Joram S. Seggev, M.D. - needs to go into 4 separate columns
Ginene Ro...
I get the "PivotTable field name is not valid" when I try to refresh the data on the attached. I inherted this from somebody who is no longer available and have not generted Pivot tables befor...
HI,
I am using excel vba to create some hydrologic calculations. I have several txtboxes and combo boxes of which i want to write the values to a spreadsheet so if the user wishes to edit ...
how can i prevent excell from updating the row reference
if i enter the formula as sheet2!d12 how can i get the refernce to count up the row.. d e f etc but keep 12
i have put this code in my sheet1vba code (alt F11):
Function nod(d1 As Date, d2 As Date) As Long
nod = DateDiff("d", d2, d1)
End Function
and I get #NAME? error when I try to use ...
I need to set up a Linear Program Model (HW Problem) to maximize profit given these constraints:
Product I am selling:
Cutlet 1 for $4/lb and must consist of at least 70% white meat
Cutl...
I'd like to be able to type in a date, e.g. "9/20" (i.e. month then day) and Excel 2007 will display it as "09/20/08" or "09/20/2008".
Right now, what Excel does is: If I type "9/20", it dis...
Hi,
This may seem very easy but somehow I am not able to do this. I have a single column stacked bar chart with 3 bars in it. I can show the value for each but I also want to show a total val...
Hi,
I need a macro which convert txt file into excel file.It ask for txt file location and then convert the txt to excel sheet.
I have a txt file with email addresses. The email addresse...
Two employees are experiencing the same problem. When trying to print the entire workbook from Excel it only prints the current worksheet. I went in and checked "Ignore print areas" and "Ent...
In Excel'97 Win 2000;
I have a workbook with two sheets. On the first sheet ("Barcode Entry" ) data is entered into columns A thru L. The input data from the columns is populated into the sec...
