|
Discontinuous Data Source for Chart?
For some reason my code keeps grabbing my entire block of data instead of the
last 6 rows. I have captured the cell addresses in variables and am trying
to capture the new ranges of data in the syntax for the chart. Not sure
where my problem resides. My data will expand by one row every week. The
headings are in cell B20 and C20. The chart code is not grabbing
discontinuous data bu...
|
1 |
12/11/2008 6:00:01 PM |
|
|
MACRO of duplicate file
Hi friend,
The below query of my was solved by "Tom Hutchins". It would be helpful if
Tom answer to this question or someone else who understands me.
Tom has given me a written Macro for Excel for my daily work which given
below. but it still need some more inputs in it.
The problem is that i key number of file in column "I",the file which is
been keyed early is also keyed twice/thrice...
|
3 |
12/11/2008 5:41:01 PM |
|
|
Insert row with formulae without contents
Catastrophe! I did not keep a copy of a macro which inserted a row above and
copied everything from the row below into the new row except any contents and
fill color. The formula in some of the cells was copied but none of the
contents so the new row was ready for entries
One of you helped with this several years ago and it has been very useful –
please help again....
|
5 |
12/11/2008 5:25:01 PM |
|
|
Lost partial contents in one cell when copy a sheet to other workb
Hi,
I need copy a sheet from a template workbook to a large batch of workbooks.
After copy using VBA, one merged cell, which has only plain text, lost some
contents in target workbooks, with only 255 characters left. How to fix it?
is this because cell format? Data type in that cell, i chose "general". if i
do use "Text", the cell displays ###################.
I'd appreciate it.
...
|
2 |
12/11/2008 5:09:03 PM |
|
|
Coping whole row to new sheet
Help please i am trying to set up a workbook with the first sheet being an
index from the index i want to be able to copy each row to following sheets
based on the first 4 numbers in the sop number i.e 01-01-xxx. i am weak with
macros so as much help anyone can provide will be appericated. Thanks....
|
2 |
12/11/2008 5:07:07 PM |
|
|
Pulling the last 6 characters out of the filename
I've got the right file open and all my numbers are crunching nicely - but I
need to drop in the date of the "data conversion" which is contained in the
last 6 characters of the filename.
How do I pull those last few characters out of the filename and drop it into
my string?
--
Regards,
John...
|
3 |
12/11/2008 5:06:10 PM |
|
|
Find duplicates, sum column then delete duplicates
I need to decipher if a row is a duplicate based on matching data in cells I,
K, L, N, and F. If the row is a duplicate, I need to add the value in cell F
to the original row's value in cell F and then delete the duplicate row. The
# of rows in the workbook changes everyday and the duplicates will not always
be right below the row it is duplicating.
Is this possible? Thanks for any ...
|
4 |
12/11/2008 5:03:01 PM |
|
|
Range Object being "forgotten"
Hello,
I have a macro that I have been using successfully for a couple of
months now that has suddenly stopped working. There are two Range
Objects that I have been using through it - FoundCell and MyCell.
About halfway through the code, they stop working and it throws a 424
error.
This is the statement where it fails. Following this is my entire code
up until this statement. I don't un...
|
2 |
12/11/2008 4:56:34 PM |
|
|
Format Cells Dialog Box
I cannot find in the Built-In Dialog Box Argument Lists where you get the
Format Cells for Number / Align / Font / Borders / Patters / Protection all
in one dialog box like it is off the menu. Is it available?
Thank you,
Steven...
|
4 |
12/11/2008 4:55:16 PM |
|
|
2007: Close to giving up !!!
I've tried installing Excel 2007, but must admit I'm close to giving up !!!
How can anything in this world be so solw and clombersome ?!?
And, also I'm finding myself spending 90% of my time looking for, what I
think is seemingly simple stuff!
Like, right now:
- Where to find the dialog for inserting and deleting names???
- Where to find the dialog for hiding and showing sheets???
...
|
14 |
12/11/2008 4:53:52 PM |
|
|
Open Dialog Box Paste Special
How can you open the Paste Special dialog box and the Format Cells dialog box
by code?
Thank you,
Steven...
|
3 |
12/11/2008 4:42:15 PM |
|
|
Retrieving email addresses from nt logins
Hi Friends and Experts,
I have an Excel application in which I have already got a table of the nt
logins of the valid users which I use to validate the user. However, I would
like the application to figure out the users full name and internal e-mail
address. This is becuase the application is expected to automatically send
e-mails etc.
Is there a way I can do this?
...
|
8 |
12/11/2008 4:38:20 PM |
|
|
Make an Array 2-dimensional in VBA
I fill an array with 4 celled ranges. The 4th cell in the Range is a price
of a part. I then use a For...Next Loop to sum those prices. I need the
array that I indicated with ">>>>" to be two dimensional (or
..aryPartDes(35)(1,4)) because I am getting a "Subscript out of Range" on the
line indicated "ERROR>>>". I think because the current array is viewed like
thi...
|
8 |
12/11/2008 4:05:40 PM |
|
|
Binding a DataSet to a ListObject
The code below successfully binds the data in the ListObject listTbl to the
data in the DataTable twsTable. However, it does not bind the column names
or the formatting of twsTable to listTbl. In other words, the column names
on listTbl show up on the Excel spreadsheet as "Column 1", "Column 2", etc.,
and the formatting/column widths is the default for the Excel spreadsheet.
How do I ...
|
6 |
12/11/2008 4:03:05 PM |
|
|
slow reading a text file into excel
Hello;
I have a macro that imports a large text file into excel; it puts the data
in every fourth column after column A (starting in A2) fills up); last week
it was running fairly fast - it took maybe 20-30 seconds to read over 70,000
lines. This week, it has slowed down considerably and I didn't make any code
changes. Tonight after letting it run for an hour, I calculate it will take...
|
6 |
12/11/2008 3:49:50 PM |
|
|
Minimize 2007 ribbon via VBA?
How to do it?!?
CE
...
|
3 |
12/11/2008 3:48:06 PM |
|
|
Check for Duplicates then Sum cells of duplicates
I am checking for duplicates in a workbook. The following is the code I'm
using:
lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Row
For i = lr To 1 Step -1
With ActiveSheet
If Cells(i, 11) = Cells(i + 1, 11) _
And Cells(i, 6) = Cells(i + 1, 6) _
And Cells(i, 4) = Cells(i + 1, 4) _
And Cells(i, 5) = Cells(i + 1, 5) Then
Cells(i, 12) = Cells(i, 3) + Cells(i + 1...
|
8 |
12/11/2008 3:15:01 PM |
|
|
Volatile function & Filter Show All
I have a function that returns the filter values of a specific cell filter.
My function is called like the following:
=GetFilterValues("B3")
'B3' in an example, it may be any of the cell on which I have a Filter On.
I put "Application.Volatile" in my code to make sure that my function is
executed each time Excel recalculates my spreadsheet.
This works fine but ...
When I have...
|
3 |
12/11/2008 3:03:21 PM |
|
|
Auto_open inputbox before showing the sheets
Hello,
I would like to create a following functionality to my workbook. When the
user opens the Excel file he sees only inputbox for password but not the
contens of the activesheet in the Excel file. I have the following code:
Private Sub auto_open()
Dim answer As String
answer = InputBox("Insert password")
If answer = "abc" Then
Sheets("Sheet1").Activate
Else
ActiveWorkbook.Close...
|
2 |
12/11/2008 3:01:29 PM |
|
|
Date Picker
Hi all, I know there is Date Picker control in excel but I want
something with "Form Control Combo Box" (as you can select 3D effect
in this combo box). I want a macro or something that when I click
combo box then a little calander should popup on the side so user can
pick a date from it and as soon as user pick the date then calander
should get unvisible. Can any friend can help please...
|
2 |
12/11/2008 2:12:01 PM |
|
|
Subtotals - add formula to blank cells
Hi:
You all probably know that when you use the subtotal function it adds a
blank line with totals below the columns that you specify. Is there a way to
get the blank lines to fill using the row above the blank cell? I can add a
formula manually but I have over 50 spreadsheets so I hoped that there was a
code that would add the contents of the row above if the cell is blank.
Example:...
|
1 |
12/11/2008 2:01:12 PM |
|
|
slow reading a file
Hello; I apologize if this is a duplicate post, but I posted over an hour ago
and it has not shown up yet.
I have a macro that imports a large text file into every fourth column.
Last week it ran fairly fast; this week it crawls. I estimate today that it
would take nearly 7 hours to import this file; last week to took 10 - 15
seconds. I haven't made any code changes, so I do not know...
|
2 |
12/11/2008 1:53:37 PM |
|
|
MACRO TO HIDE BLANK ROWS
I have developed a model that has 190 lines but certain cells are blank ie
(-) and i would like to hide that row were a certain cell is blank. How do I
write code for the macro to start at say C1 and then move down to C2 etc and
then when it finds a cell that is blank ( but contains a lookup formula) it
will hide that row and then continue until say come to c192 which contains
the word E...
|
7 |
12/11/2008 1:49:02 PM |
|
|
Text boxes in forms
Hi,
I'm sure this is a really easy one, but...
I have a set of forms that capture user-inputed data. Each form uses text
boxes to record the input and copy it to specific cells on a spreadsheet.
When users need to input several different items into the same text box, how
do I capture the carriage return to put these on different lines within the
same box? At the moment, the carriage...
|
2 |
12/11/2008 12:58:08 PM |
|
|
Worksheet Sharing VBA
The following VBA code runs great when the Workbook is not Shared or
Protected. When I do Share The Workbook, the code takes over a minute to
copy each row of data. I am forced to cancel the run (via the ESC key) and
recieve the following message "'Run Time Error 1004': Copy Method of Range
class failed". Do I need to adjust my code to execute in a "Shared
Workbook"? If so, how? Cou...
|
4 |
12/11/2008 3:32:41 PM |