|
More site info...
Discussions in microsoft.public.excel.programming - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.excel.programming:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
342
|
1,080
|
3,628
|
|
Post:
|
910
|
3,090
|
11,241
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.excel.programming (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.excel.programming posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.excel.programming Alexa graph:
|
Top authors on Discussions in microsoft.public.excel.programming during last week:
user's latest post:
Indirect addressing in...
Published (2009-11-26 10:47:00)
You cannot do that unless sys is an array. Dim sys(2) as Variant For X = 1 to 2 sys(X) = CurrentSystemValue Next If this post helps click Yes --------------- Jacob Skaria "GC" wrote: > Hello, > > I have 2 variables called sys1 and sys2. I need to assign values to these 2 > variables within a loop. > i.e. > For X = 1 to 2 > sys(X) = CurrentSystemValue > Next...
user's latest post:
VBA equivalent for Excel...
Published (2009-11-26 08:51:00)
You can refer to the range referenced in A1 with Range(Range("A1").Value), for example... Set DefinedNameRange = Range(Range("A1").Value) or... MsgBox Range(Range("A1").Value).Address
user's latest post:
UserForm show question in...
Published (2009-11-26 21:01:00)
I am not sure I understand the question, but you can call a UserForm anytime from any code module because it is a separate object. But if it is already visible you cannot open a second instance of it. The TextBox has a double click event that could be used, but not a single click. There are other events such as enter and exit that could also be used to call a userform. You can view these events by creating a textbox from the...
user's latest post:
Compare two arrays in...
Published (2009-11-26 21:31:00)
You could use the join statement to make them both a string and then compare Str1 = join(Array1,",") Str2 = join(Array2,",") if Str1 = Str2 then -- joel ------------------------------------------------------------------------ joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=157541 [url="...
user's latest post:
ADO connect mysql in...
Published (2009-11-25 11:56:00)
http://forums.mysql.com/read.php?10,100302 Tim "Li Jianyong" <LiJianyong@discussions.microsoft.com> wrote in message news:56BC5ABE-CBB6-4F76-B956-32153ECDB5AD@microsoft.com... > Dear Sirs, > > I want to use mysql as database,and work on the datas through ADO in the > excel. so I get exchange the datas with Excel and mysql. This is best way > for > my works I...
user's latest post:
Use VBA to change row height or...
Published (2009-11-26 16:21:00)
Ok... the following code allows me to change the dimensions of a row: Rows(1).RowHeight = 30 This works fine, but now I noticed that Excel will not allow me turn of my headings. When I click "View" and I try to uncheck the "Headings" option, my headings will not turn off. What happened here? "Robert Crandal" <nobody@gmail.com> wrote in message...
user's latest post:
Extracting names and titles in...
Published (2009-11-26 15:01:00)
"andreashermle" <andreas.hermle@gmx.de> wrote in message news:7bfec790-5975-41e7-ab0b-83a392929862@m3g2000yqf.googlegroups.com... On Nov 26, 6:24 pm, "Peter T" <peter_t@discussions> wrote: > Sub test() > Dim i As Long > Dim s As String > Dim sArr() As String > s = "Dr. med. Betty Eastwood" > sArr = Split(s,...
user's latest post:
How do you send data to the same...
Published (2009-11-25 12:20:00)
Hi Bernard, Someone might be able to answer your question to do this but if not then I would give consideration to writing it to another Excel workbook with only one worksheet and then Save the Excel workbook as a text file. The workbook could become the master and just overwirte the text file each time.
user's latest post:
Newbie with a desgin question in...
Published (2009-11-26 18:05:00)
One option is to use a dynamic named range defined using the OFFSET function. YOu'll want something like this =OFFSET(A3, 1, 0, COUNTA(A:A), 1) A3 is the reference 1 row down from A3 0 columns to left or right of A3, Resize the range to be count of the non-empty cells in A. YOu may need to adjust this a bit. 1 column wide Adjust to suit.
user's latest post:
Macro to Un Hide filtered rows...
Published (2009-11-25 15:46:00)
Sub Macro2() Const csPWORD As String = "123" With activeworkbook.worksheets("broker") .unprotect password:=cspword 'to remove the filter and the arrows .AutoFilterMode = False 'or to just show all the data and keep the arrows If .FilterMode Then .ShowAllData End If .protect password:=cspword End With End Sub JeffK wrote: > > I have this Macro > > Sub Macro2()...
|
|
|
Top 10 active forums on Discussions in microsoft.public.excel.programming during last week:
|
|
Top 10 forums on Discussions in microsoft.public.excel.programming:
|
|
|
|
Latest active threads on Discussions in microsoft.public.excel.programming:
Started 1 day ago (2009-11-27 16:06:00)
by Don Guillett
Have you tried a right click>copy>>
Started 1 day ago (2009-11-27 15:21:00)
by JE McGimpsey
One way:
Save your workbook as "Read Only" (Save As/Options/Read-only Recommended)
It's nearly impossible to make any solution foolproof, since fools are
so ingenious. You could use VBA to replace the Save command, but that
can be thwarted by opening with macros disabled. You can use VBA to make
it difficult to open the ...
Started 1 day ago (2009-11-27 16:06:00)
by Don Guillett
Basic idea. Modify to suit
Sub addtoformulawithvba()
With ActiveCell
MsgBox .Formula
..Formula = .Formula & "+d2"
End With
End Sub
Started 1 day ago (2009-11-27 16:01:00)
by Dave Peterson
If you're in the userform_initialize event (or anywhere in the userform module),
you could use:
With Me
(instead of With Userform1)
so
dim iCtr as long
for ictr = 1 to 13 'lbound(myArray) to ubound(myArray)
me.controls("txbox" & ictr).value = myarray(ictr)
next ictr
The names and array ...
Started 1 day, 2 hours ago (2009-11-27 14:07:00)
by Gary''s Student
Include a line like this:
Application.Goto Reference:=Worksheets("Sheet1").Range("A1"), scroll:=True
Started 1 day, 5 hours ago (2009-11-27 10:41:00)
by Ron de Bruin
Start here
http://www.rondebruin.nl/copy5.htm
Started 1 day, 2 hours ago (2009-11-27 13:16:00)
by Mike H
Hi,
Private Sub CommandButton1_Click()
Call DateStamp
End Sub
Mike
"Roger on Excel" wrote:
> [Excel 2003]
>
> I use macros in a worksheet - for example:
>
> Sub DateStamp()
> Range("b14") = Date & " " & Time 'Date And Time
> End Sub
>
> I access the macro with a ...
Started 1 day, 8 hours ago (2009-11-27 07:24:00)
by Barb Reinhardt
What specifically are you having issues with. I typically don't download
files from this site, but if there are questions you have, we may be able to
help.
|
|
Hot threads for last week on Discussions in microsoft.public.excel.programming:
Started 5 days, 12 hours ago (2009-11-23 04:03:00)
by Sam Wilson
Hi,
You have to have the sheet open to get the data from it. The following is as
seamless a way as I can think of to leave the user unaware of this:
Sub test()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim wb As Workbook
Set wb = Workbooks.Open("C:\path\test.xls")...
Started 1 week, 2 days ago (2009-11-19 14:03:00)
by Barb Reinhardt
You may need to change
Dim mQuestion1Range, mTimeRange, mPositionRange As Range
to
Dim mQuestion1Range as Range
Dim mTimeRange as Range
Dim mPositionRange As Range
Started 1 week, 1 day ago (2009-11-20 09:16:00)
by Mike H
Hi,
I wouldn't 'remove' the lines I'd copy the edited data elsewhere like this.
Change SrcSheet to the sheet containing data
DestSheet to where the data is to go
MyStep to the required step
Sub Mariner()
Dim DstSheet As String
Dim SrcSheet As String
Dim LastRow As Long, MyStep As Long
Dim ...
Started 1 week ago (2009-11-21 05:54:00)
by Mike H
Try this
Right click the QA Toolbar and select Customise.
From the left dropdown choose ' Macros' and scroll to your macro and then
click ADD
On the right click modify and from the popup select an Icon
OK
Mike
"Gary''s Student" wrote:
> Excel 2007
>
> is it possible to put something on...
Started 3 days, 12 hours ago (2009-11-25 03:36:00)
by ab
I don't even know if you can do that without simply looping through
your temprange and then putting each value into your target range
according cell.
What you can certainly do (instead of the looping i mention above) is
actually copy/paste[transpose] it - something along these lines:
rngTemp.Copy
wsDest.Range("A" & ...
Started 1 week, 1 day ago (2009-11-20 08:41:00)
by Barb Reinhardt
You may want to post your selectionchange code.
Started 4 days, 3 hours ago (2009-11-24 12:55:00)
by OssieMac
Hi Oldjay,
Note when copying a worksheet with the below method then the command buttons
with their associated VBA code will be copied with them. Therefore it is a
good idea to place most of the code in a standard module and just call the
code from the command buttons. That way you are not duplicating code
throughout your ...
Started 2 days, 5 hours ago (2009-11-26 10:51:00)
by Steve Yandl
Gordon,
Your idea to copy into a new file is a good option. The example below
assumes a workbook with three sheets. It will retain data and formatting
while leaving behind VBA in modules.
'-----------------------------------
Sub SaveWithoutMacro()
Dim intOpens As Integer
intOpens = Application....
Started 1 week, 1 day ago (2009-11-20 06:07:00)
by Barb Reinhardt
Are you running the macro each time the chart title changes?
Barb Reinhardt
"Trond" wrote:
> I have programmed a macro that makes a pivottable and a pivotdiagram. In this
> diagram I have a charttitle that I want to be equal to the content of one
> cell (D2).
> So if the content of the cell changes...
Started 1 week ago (2009-11-21 15:24:00)
by Mike H
Hi,
When you dim your variable by default it is set as nothing which for an
integer variable is the same as zero which can be demonstrated with this bit
of code
Dim cnt As Integer
MsgBox cnt + 10
If you try this you will find the message box displays 10 so cnt was zero
Mike
"Pawan" wrote...
|
|
Size: 251 bytes
