|
Hiding automated spreadsheet activity
I have an excelspreadshett with several sheets. I have automated the
spreadsheet with VB Excel. There is a lot of activity moving data from one
spreadsheet to another. In action, it is very disturbing to the user as the
code switches back and forth between sheets, across columns, etc. It gives a
fast flickering effect.
How can I hide this activity while hte code is executing?
Tha...
|
3 |
12/31/2008 10:14:05 PM |
|
|
Uploading files:Not sure if this is an easy or hard one
Hi
I am creating a form in excel, and one of the prompts on the form is to
browse and upload a file (like any other upload file function where you can
just browse and upload). What i would like to do is to be able to just click
on the 'browse' button and select the file, then for the file path to be
copied into excel as just a hyperlink (so that when you click on that
hyperlink, it w...
|
5 |
12/31/2008 10:00:01 PM |
|
|
UDF Not Returning Array to Range
Hello,
In the following function below, I am trying to select a range of cells
containing text, extract the numbers from those text strings, assign each
string to an array index, and finally return the array as a range. I haven't
used an array in a function before, so I'm sure my error is there. The
number-extracting part works fine (the "Digi" loop) as I have used it
elsewhere, but ...
|
7 |
12/31/2008 9:46:15 PM |
|
|
How to put formulas into blank cells from VBA when something is entered?
Hey, sorry for the title. It's late here in Africa. Happy new year
btw!
I need two relatively simple things.
1) I have a recorded macro that just copies a bunch of cells and then
pastes them into the row below. Trouble is, they have direct cell
references (ie. "B3:F3") which I would rather just be referred to as
offsets from the activecell. Unsure how to do this in VBA though.
2) I wo...
|
9 |
12/31/2008 9:24:32 PM |
|
|
Sneding email thru VBA (using Exchange)
I have seen references to using VBA in Excel to send sheets/books to
recipients. Usually questions are directed to Ron deBruin's site
(http://www.rondebruin.nl/cdo.htm). However I have two issues.
[1] I am sending using an exchange server and the references are for using
SMTP. How is using an Exchange Server different?
[2] I'd like to send the file as an attachment but could not fin...
|
1 |
12/31/2008 9:13:02 PM |
|
|
Data Validation Formula
Geetings,
I'm trying to use data validation to only allow letters or numbers to be
entered in a cell (I don't want the user to enter any symbols). Can you help
me write a formula for that?
Any help would be GREATLY appreciated!...
|
9 |
12/31/2008 9:12:02 PM |
|
|
Print Code
Greetings...
I have a little code I am needing some assistance with. The code is suppose
to print out certain sheets based on wether a particular cell on another
sheet is empty or not. If the cell is empty the sheet should not print...if
cell is not empty, the sheet should print.
Here is what I have....any assistance will be greatly appreciated!
..........................................
|
5 |
12/31/2008 9:03:01 PM |
|
|
Access Coding Question
Hello everyone,
What I am attempting to do is to run a macro on a database that I
created. I can run this just fine since I have the full MS Access
version on my PC, but when I go to others machines that have the
runtime versions, they cannot run it. I get a ActiveX object error. I
have the Access Object Libaray(sp) checked in my References.
Has anyone ran into the problem before, and if...
|
1 |
12/31/2008 9:00:18 PM |
|
|
Can anyone correct this code ???
This code is designed to delete rows which dont have data in column I.
However, after several hours running, it just freezes up the s/s and I
have to close it down.
Code:
--------------------
Sub delRows()
Dim rClear As Range
Dim Rw As Long
Dim LastRw As Long
With ActiveSheet
LastRw = .Cells(.Rows.Count, 1).End(xlUp).Row
For Rw = LastRw To 3 Step -1
...
|
9 |
12/31/2008 8:57:38 PM |
|
|
How to auto hide a row if the first cell is blank?
Ok I have checked for postings on this problem but none of them have an
answer to my "unique" question.
What I want to do is hide an entire row if the first cell is blank but the
"blank" cell has a formula.
For example:
Let’s say cell A25 has the following formula if(A24="33","Please input
data"," "), so if A24 does not have the number 33 or if it is blank then the
cell A25 will be ...
|
3 |
12/31/2008 8:48:00 PM |
|
|
Excel file for deliberations on proper entry date into a retirement plan
Excel file for deliberations on proper entry date into a retirement
plan
I work on an Excel file to determine property date of entry. While I
have not completely worked out all of the bugs or the permutations or
problems that may come up, I do feel that I have discerned an
important part of the problem. The sheet where I set up my formulas
and functions has the name 410a elig and coverage ...
|
2 |
12/31/2008 8:41:09 PM |
|
|
Run a macro only when deleing a row
Can anyone get me started on where I might put some code that runs when a row
or any cell is deleted in the worksheet?
--
B Good Lad...
|
8 |
12/31/2008 8:27:01 PM |
|
|
Copy Formula Code
Can anyone please give me a code that copies the preceeding cell and inserts
the formula only into the selected cell?...
|
4 |
12/31/2008 8:16:00 PM |
|
|
Multiple Countif - i,j,l counters probably mixed up
"Summary" Worksheet
A B C
1. Project Crit ProjCrit
2. Bravo 1 Bravo1
3. Bravo 1 Bravo1
4. Bravo 1 Bravo1
5. Bravo 2 Bravo2
6. Bravo 2 Bravo2
7. Bravo 3 Bravo3
8. Delta 2 Delta2
9. Delta 2 Delta2
wanted "PoStatus" Worksheet after following code execution
to summarize...
|
5 |
12/31/2008 7:37:52 PM |
|
|
Code Formula
All:
I am in need of code help for inserting a formula down a column of 26 rows.
I typed the formula and copied it down to the last cell but that will not
work for the next time I use the macro since it will be the next column. Any
help is greatly appreciated.
Thanks
Nikki...
|
4 |
12/31/2008 7:20:30 PM |
|
|
Using combobox to find column
I am working on a rolling 12-month budget spreadsheet. The first of the 12
months can be any month.
What I would like to do is have a combobox populate the months in order Jan,
Feb, etc. Then when the user selects say June it will select the column in
which June resides. Keep in mind that June could be anywhere in the first 12
columns.
I can populate the combobox, but the order the m...
|
5 |
12/31/2008 6:46:00 PM |
|
|
Delete Rows
Hi, I have a worksheet that is constantly changing in range size and need a
piece of code that can delete all rows below the last row containing data in
column K bar 10. I say column k because there are formulas that run down
other columns and column K has just values.
I have been using:
Sub Delete_Rows()
Application.ScreenUpdating = False
Dim Firstrow As Long
Dim Lastrow As L...
|
6 |
12/31/2008 6:40:02 PM |
|
|
For Each minor problem
i've done this kind of thing a thousand times, but i can't get this
one to work.........
'===========================
Dim cell as Range
myLastSusanRow = ws3.Cells(10000, 1).End(xlUp).Row + 1
Set rSusan = ws3.Range("a2:a" & myLastSusanRow)
For Each cell In rSusan
If cell.Value = Me.txtBook.Value Then
'minor stuff
Else
'do nothing
End If
Next cell
'=================...
|
9 |
12/31/2008 6:28:49 PM |
|
|
Personal macro workbook
I have just installed excel 2007 and kepping excel 2003 also.
Now whenever I open Excel2003 or 2007, personal.xls opens and shows
visibali on my start bar.
Earlier it was not showing.
Can anybody help please?
Thanks.
Ketan...
|
5 |
12/31/2008 6:23:46 PM |
|
|
Userforms
I'm a beginner with a little bit of experience with VBA and No experience
with Userforms. I want to be able to build a combobox on UserForm1 based on
an array that I created in Module1, but I can't seem to figure out if I add
code in the UserForm or the VBA module. I think once I understand this
interface I'll be okay, but maybe I'm trying to do something that can't be
done.
Bob...
|
10 |
12/31/2008 6:22:02 PM |
|
|
Replace Underscores Between Words from an Object with a Single Spa
I have an object that is filled with many underscores between texts. I
recently got help from your forum on how to remove leading underscores which
works great and now I need help in replacing a line of underscores between
words with a single space.
Thank you again for your help!...
|
8 |
12/31/2008 6:20:28 PM |
|
|
When excel is opened need to ask a question
What day of the week it is and open a certian workbook and run a
certain macro. New to this and need some help. Do now somewhat about
vb that works inside of excel.
I would be Thankful for any help.....
|
2 |
12/31/2008 5:45:02 PM |
|
|
IS THERE A WAY TO SEARCH FOR AND CALCULATE MULTIPLE EXCEL FILES?
IF GOT MULTIPLE WEEKLY TIME SHEETS IN A FILE ON A SERVER AND NEED TO BE ABLE
TO RUN A SEARH FOR THE ACTIVE WEEK AND PREVIOS WEEK AND CALCULATE TIME FOR
EACH EMPLOYEE BY NAME OR ID #. EACH TIME SHEET HAS 7 TABS 1 FOR EACH DAY OF
THE WEEK. IS THIS POSSIBLE WITH THE USE OF MACROS OR FORMULAS?
--
THANKS
BRIAN...
|
2 |
12/31/2008 4:59:01 PM |
|
|
Close msgbox automatically
Hello, me again.., I'm trying to close a msgbox using application.ontime now
+ 5seg
Thank you in advance
--
Thank you......
|
19 |
12/31/2008 4:46:25 PM |
|
|
Combo Box Drop Down Button
Hi all, I have two Combo Box on my sheet. One is Combo Box (Form
Control) and other is Combo Box (ActiveX Control). My question is
that when I change hight or width of Combo Box (Form Control) then the
size of Drop Down arrow Button also changes but remains in squar
shape. But when i change hight or width of Combo Box (ActiveX
control) then the size of Drop Down arrow Button doesn't remai...
|
2 |
12/31/2008 4:38:49 PM |