|
More site info...
Excel Help/VBA Help: - www.ozgrid.com | Site profile
|
|
Site profile page for http://www.ozgrid.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.ozgrid.com.
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.ozgrid.com 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 Excel Help/VBA Help::
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
112
|
417
|
1,122
|
|
Post:
|
226
|
890
|
2,284
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Excel Help/VBA Help: (http://www.ozgrid.com)
|
|
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.
|
|
|
|
|
Excel Help/VBA Help: posting activity graph:
|
|
http://www.ozgrid.com Alexa graph:
|
Top authors on Excel Help/VBA Help: during last week:
user's latest post:
Delete Personal Macro Workbook
Published (2009-11-28 21:05:00)
If you don't need it, delete it. C:\Users\ UserName \AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB
user's latest post:
Salesmen Sales & Hours...
Published (2009-11-28 15:15:00)
Hi, I'm interested. As Dave said, please attach a sample workbook.
user's latest post:
VBA Macro To Search All Sheets...
Published (2009-11-25 14:41:00)
The receipt is a receipt for payment we will receive from parents with children in the childcare program. The employee will complete the receipt and print it out for the parent making the payment at the time the payment is received. The Accounts Receivable workbook is the record of what has been charged and paid for each child in the program. When our employee is completing the receipt I would like the macro to search the accounts receivable...
user's latest post:
Sum By Multiple Criteria &...
Published (2009-11-25 14:41:00)
Ok. I have tried the exact syntax you have suggested and I still get the standard "Your formula contains an error " message. This is the formula I entered in C11. C9 is unmerged- Please notice this is SUMIFS not SUMIF. =SUMIFS(INDIRECT("'" & C9 & "'!$F$2:$F$7122,INDIRECT("'" & C9 &...
user's latest post:
Do While Interior Color Is None
Published (2009-11-27 15:07:00)
Interior refers to just what it says the "interior" property of the object which you are referencing. Briefly, in Excel you may manipulate the properties of objects. Objects include but are not limited to: Workbooks, worksheets , cells , charts , chart titles, etc. See this link for more on the Object Model: Excel VBA Object Model In your example, interior refers to the interior of a cell object and you are comparing its...
user's latest post:
Check If File / Workbook Exists
Published (2009-11-28 15:06:00)
I'd appreciate some help with a macro to check if a file exists before saving . The code saves the file OK if the filename does not exist but fails if it does. VB: AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy /pasting, but IS if the keyword uses "quotes". Sub CheckFileName() Dim FName As String FName = ThisWorkbook . Name 'saves file Dim FPath As String FPath =...
user's latest post:
List All Hidden Page Field Items...
Published (2009-11-23 13:56:00)
QUESTION UPDATE: Dave's solution above only partly works. It works perfectly when a page filter other than "(All)" is selected. Where the page filter contains "(MultipleItems)" ie where pivot items are hidden but "(All)" visible items are selected, Dave's solution lists all page filter header items as hidden. This is not the case . Only some of them have been hidden. So to...
user's latest post:
Air Traffic Control Worksheet -...
Published (2009-11-24 14:06:00)
Well, I think we should give Dr the first move . I have time this week to do it so I'm available if doesn't.
|
|
|
Top 10 active forums on Excel Help/VBA Help: during last week:
|
|
Top 10 forums on Excel Help/VBA Help::
|
|
|
|
Latest active threads on Excel Help/VBA Help::
Started 1 day, 17 hours ago (2009-11-28 21:05:00)
by Dave Hawley
If you don't need it, delete it.
C:\Users\ UserName \AppData\Roaming\ Microsoft\Excel\XLSTART\PERSONAL. XLSB
Started 1 day, 17 hours ago (2009-11-28 21:05:00)
by Dave Hawley
No attachment and you haven't stated what you want someone to do for you.
Started 2 days, 23 hours ago (2009-11-27 15:05:00)
by Dave Hawley
VB : AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy /pasting, but IS if the keyword uses "quotes".
Application.Undo
you can't undo Macros though. Keep a copy somewhere and paste over the top.
Started 1 day, 23 hours ago (2009-11-28 15:15:00)
by Dave Hawley
Please attach an example so others can help, thanks.
Also, please keep ALL correspondence in this forum, thanks.
Started 1 day, 23 hours ago (2009-11-28 15:06:00)
by mikerickson
Have you tried GetOpenFileName , the dialog it calls will resolve duplicate file names
VB : AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy /pasting, but IS if the keyword uses "quotes".
Sub test()
Dim myFileName As String
myFileName = Application.GetSaveAsFilename
If myFileName = "...
Started 2 days, 23 hours ago (2009-11-27 15:07:00)
by AAE
Interior refers to just what it says the "interior" property of the object which you are referencing.
Briefly, in Excel you may manipulate the properties of objects.
Objects include but are not limited to: Workbooks, worksheets , cells , charts , chart titles, etc.
See this link for more on the Object Model:
Excel VBA Object Model
In your example, interior refers ...
Started 6 days ago (2009-11-24 13:55:00)
by Dave Hawley
No formula can do that. VBA or nothing. Your choice.
VB : AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy /pasting, but IS if the keyword uses "quotes".
Function GetList(rRange As Range ) As String
Dim rCell As Range, lCol As Long , lcolStop As Long
Dim strList As String...
|
|
Hot threads for last week on Excel Help/VBA Help::
Started 1 week ago (2009-11-23 14:06:00)
by Ger Plante
Hi Aon, the PPT file with screenshots is missing.
Ger
Started 6 days ago (2009-11-24 14:07:00)
by Krishnakumar
Hi,
Got the payment and thanks.
Started 1 day, 23 hours ago (2009-11-28 15:06:00)
by mikerickson
Have you tried GetOpenFileName , the dialog it calls will resolve duplicate file names
VB : AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy /pasting, but IS if the keyword uses "quotes".
Sub test()
Dim myFileName As String
myFileName = Application.GetSaveAsFilename
If myFileName = "...
Started 1 week, 2 days ago (2009-11-21 11:12:00)
by RolfJ
Try this
VB : AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy /pasting, but IS if the keyword uses "quotes".
Dim sh As Worksheet
Set sh = ActiveSheet
Dim ch As ChartObject
Set ch = sh.ChartObjects(1)
Dim xAxis As Axis, yAxis As Axis
Set xAxis = ch. Chart .Axes.Item(1)
Set yAxis = ch.Chart....
Started 1 week, 2 days ago (2009-11-21 11:12:00)
by Dave Hawley
Something like
VB : AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy /pasting, but IS if the keyword uses "quotes".
Sub ListHiddenPageFilterPivotItems()
Dim wb As Workbook
Set wb = ThisWorkbook
Dim ws As Worksheet
Set ws = wb.ActiveSheet
Dim pvt As PivotTable
Dim pf...
Started 1 week, 4 days ago (2009-11-19 08:28:00)
by Dave Hawley
Try like;
VB : AutoLinked keywords will cause extra spaces before keywords. Extra spacing is NOT transferred when copy /pasting, but IS if the keyword uses "quotes".
Sub SearchAllSheets()
Dim ws As Worksheet
Dim rFound As Range
On Error Resume Next
For Each ws In Worksheets
With ws.UsedRange
Set rFound = . ...
Started 3 days, 22 hours ago (2009-11-26 15:39:00)
by zhuanyi
By the way, I am running on Windows XP and Excel 2003 and 2007 installed.
Started 1 week, 2 days ago (2009-11-21 11:12:00)
by Ger Plante
Hiya Def,
Consider carefully the information in the following thread (and the threads mentioned within the thread).
Using a list box to jump to a particular sheet in a workbook
Alternatively, if you are struggling with this...
If youre sheet name is to be constructed from 2 cells in Column A and Column B (and assuming those cells are side by side (say A1 and A2), then ...
Started 1 week, 2 days ago (2009-11-21 11:13:00)
by Lorien
I am trying to create a macro that will copy a sheet , move it to the end and rename it it with the next date of the value of the date in a particular cell .
I can do the first part no problem, however I am stuck with naming the sheet with the date which is the next day from the date value in a cell.
i.e. If the date value in A1 of the copied and moved sheet is 11 Nov 2009 I ...
Started 6 days ago (2009-11-24 14:06:00)
by needexcelhelp77
I have an Excel spreadsheet with data all in one column and I would like the script to parse out six pieces of data ( name , address, city, state, zip , phone) and put that data in a different excel spreadsheet, but each piece of data parsed out must be put in the appropriate column. The columns in the new spreadsheet will be (name, address, city, state, zip, phone).
For each item ...
|
|
Size: 1,127 bytes
