Description:
Microsoft Office Excel newsgroup.
|
|
|
Flat Trend Line
|
| |
Hi,
I'm needing some help again in Excel. I have a downward sloping trend
(determined by using the TREND function in Excel). I need to create a
flat trend line based on the TREND data populated. The ultimate goal is
to have a flat line versus a downward sloping trend line. From this
data, I will continue with my modeling, but just need some help with... more »
|
|
|
MACRO Effeciency
|
| |
...
...
I make no promises about this code, but...
Sub workerFunction()
ActiveWorkbook.Sheets.Select
MZING81
Removetextrow 'Compile error: Sub or Function not defined
removeEmptyCells
UnMerge
filter
remerge
Text1 'Using just "Text" is a bad idea...... more »
|
|
|
The size of the ActiveX ListBox control shrinks
|
| |
I am unable to maintain a set size of the ActiveX Listboxes on my
Excel worksheet.
In Properties I set the size of each to a height of 40 and width of
240 and use the font Arial-Regular-14
After saving the file and then re-opening the sizes change to a height
of 22.5 and width of 148.5
Is there a way to lock the size so it does not change? In Properties... more »
|
|
|
Splash screen not working in hidden workbook
|
| |
Hi,
i like to use a splash form in a HIDDEN WORKBOOK, but it seems to be
not working.
Problem is that the frmErrorMsg keeps open after the 5 sec. delay, so
there's no Unload event, because the "Close Form" routine isn't
called.
Is there a possibility to get this working in a HIDDEN WORKBOOK (Add-... more »
|
|
|
vba in excel 2007
|
| |
I have a vba program written in excel 2003 and am trying to get it to run in excel 2007.
The program gives a runtime error 5 "Invalid procedure call or argument" at the statement
Selection.Characters(Start:=2, Length:=5).Font.Name = "Arial"
Could someone tell me how to correct this please.... more »
|
|
|
Populating worksheet based on multiple worksheets
|
| |
I have 86 worksheets with data that I need to populate an "upload"
sheet. Each worksheet will have its own column. I manually did the first
sheet and really dont want to have to do 85 more.. Is there a macro i
can use to do this for me? My file exceeds the max limit here, so if
anyone needs to see it then I can email it or find another way to upload... more »
|
|
|
Delete rows autofilter range problem
|
| |
Hi and thanks in advance,
I am using Excel 2003
I have a delete rows macro that tests whether there is data in one or
more user defined columns on the sheet and if not, places an "X" in the
first blank column to the right of the data. I then apply an autofilter
to pick up all rows with an "X" and then would like to delete all the... more »
|
|
|
Opening an Excel File
|
| |
The following code tests whether a file is open on my computer and if
it isn't, it opens the file, and if it is already open, it tells me
that.
sub OpenMyFile()
dim myPath as string
dim myFile as string
dim wkbk as Workbook
myPath = "R:\share\ . . . Folder\"
myFile = "SomeFileName.xlsm"... more »
|
|
|
