Thanks a LOT Basole,
That did the trick! :D
Tom
On Tuesday, January 14, 2014 1:05:19 PM UTC, Basole wrote:
> Dear Tom,
> Test attachment.
> For this case, I think this solved, let's see the next chapters.
>
> Basole
>
>
>
> Em quarta-feira, 8 de janeiro de 20
Basole,
Thanks for this!
The numbers can be anywhere from 001-400, so will always be 3 digits. The
ending will always be K but the beginning could be nothing (i.e. just ###K)
or it could be B (i.e. B##K) or finally it could be TN (i.e. TN###K)
Hope that helps
Thanks
Tom
On Monday, January
It's all working well in the master sheet! except we've reached batch 10
and that batch is going to the top of the list rather than the bottom ie.
*B010K * 001K 002K 003K B004K B005K B006K 007K 008K 009K
do you know why that has happened?
Tom
On Monday, January 13, 20
Ok thanks for all your help, i'll get in touch if I have any more problems!
Thanks for everything
Tom
On Monday, January 13, 2014 12:20:20 PM UTC, Basole wrote:
> No problem. Since the batch number, the end has the letter "K" the code
> search this number, regardless of the
Sorry, i should have explained better, the batch number can go up to about
400 over the year, so it needs to be able to order data from 001K all
the way up to 400K (any of the numbers could be B???K or TN???K as well...)
does that help?
Thanks
Tom
On Monday, January 13, 2014 11:05:32 AM UTC
erent workbook?
Thanks
Tom
On Saturday, January 11, 2014 1:19:30 AM UTC, Basole wrote:
> Hi Tom,
>Check the attachment,
> I adjusted the code to look at the tab and Tryfan (column "D") only
> cells that contain the letter "K"
>because it is the onl
Basole,
That's incredible, how do you do that?!
is there any way to do it which the whole row and copy the rows into a
different sheet?
Thanks for all your help
Tom
On Thursday, January 9, 2014 12:33:45 PM UTC, Basole wrote:
> Dear Tom, here me the macro is working perfectly. I am att
Hi Basole,
The first step worked but the other two both had errors and I couldn't run
them.
is there anything you can suggest?
Thanks
Tom
On Wednesday, January 8, 2014 3:41:14 PM UTC, Basole wrote:
> 'Hi Tom Yaxley,
>
> 'try this macro, copy and paste the code in shee
appear as such:
001K
002K
003K
006K
(varying number of rows)
B004K
B005K
B007K
etc..
they need to become:
001K
002K
003K
B004K
B005K
006K
B007K
is there anyway to do this? (i cannot post the spreadsheet as it is
confidential data)
Thanks
Tom
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
2013 03:36:42 UTC+5:30, Tom B. wrote:
>>
>> Hi
>>
>>
>>
>> I have a spreadsheet that records user inputs and then stores the inputs
>> along with Date/Time and user ID.
>>
>> Since this will be accessed on a shared computer, that User
I have a range of data that has 5 columns P:T, (Asset No, Part No, Lot No,
Date/time stamp and User ID) and up to 3000 rows, for now. I have Command
Button with code that works fine for retrieving all rows that have a
specified asset numbers (Input cell C5).
I just want to include Buttons wit
after modifying it, that would
be the preferred method. If not, do you know of a way to reach out to a
file directory and rename files through a macro?
Thanks,
Tom
On Wed, Nov 23, 2011 at 5:27 AM, deepu wrote:
> Hi Tom,
>
> Just want to ask you before I answer to your query..
?
Thanks again,
Tom
On Tue, Nov 22, 2011 at 8:01 PM, Asa Rossoff wrote:
> Hi TomR,
>
> ** **
>
> You can use the same technique you use to increment the row selected at
> the end of the loop to reference cells in the selected row: the Offset
> property.
>
>
Asa, just tried the code you provided. It works great!
You ROCK!
Thanks again,
Tom
On Tue, Nov 22, 2011 at 8:01 PM, Asa Rossoff wrote:
> Hi TomR,
>
> ** **
>
> You can use the same technique you use to increment the row selected at
> the end of the loop to reference cel
I tested it with dates that exist but still got the same error
message.
You can try it.
Tom
On Jul 26, 3:42 pm, "Rajan_Verma" wrote:
> If error is coming it means yourdatenot found in that sheet..
> ' On the Top on Module
> On Error Goto Err:
>
> 'Before End s
sibly incorrect
myDate = Application.InputBox("What date are you looking for?",
Type:=1)
Cells.Find(What:="myDate", After:=ActiveCell, LookIn:=xlFormulas,
_
LookAt:=xlPart, SearchOrder:=xlByColumns,
SearchDirection:=xlNext, _
MatchCase:=False, SearchF
t; Suppose your are working on the file 1
> you want to switch and in file 2 then you can just insert the
> hyperlink the in a1 of file 2 and refer to the file 1.
> Just by click you can jump to file 1.
>
> On Feb 1, 11:47 am, Tom wrote:
>
>
>
> > I hope there is an expert
t; <--- Red
> ' LookAt:=xlWhole, SearchOrder:=xlByRows,
> <--- Red
> SearchDirection:=xlNext, _
>
content is a blank.
Thank you if you can help
Tom
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http
High, the
Low and the Volume traded for that day.
How can I transfer the corresponding information to fill the blanks in
WorkbookA and to skip a line if a code in WorkbookB is missing when it
is not traded on that day? Thank you for your help.
Tom
How can I get my created floating menu bar to lock and position
itself
automatically to the right of the screen when I boot up Excel 2003?
Thank you for your help.
Tom
--
--
Some important links for excel users:
1
nge("whatever is chosen"),
Wonder if the following would work?:
Selection.Sort Key1:=ActiveCell, ...
> Paul
>
>
>
> - Original Message
> > From: Tom
> > To: MS EXCEL AND VBA MACROS
> > Sent: Fri, November 5, 2010 8:38:06 AM
&g
location is unknown. Can anyone figure out how
this could
be done?
TIA,
Tom
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Joi
There is an excellent spreadsheet compare addin you can upload from
http://sourceforge.net/projects/spreadshcompare/
It can easily do what you want.
On Tue, Apr 27, 2010 at 10:51 AM, sudhir wrote:
> Dear friends , i m waiting for reply,
> thanks
>
> On Apr 26, 8:59 pm, sudhir wrote:
> > Dear
I have a formula that works, but I'm not sure how the INDEX function
> > is working:
>
> > =MATCH(1,INDEX(--(ATM!$C$3:$AJ$3=6),0),0)
>
> > The INDEX part of the above sea
Hi,
I have a formula that works, but I'm not sure how the INDEX function
is working:
=MATCH(1,INDEX(--(ATM!$C$3:$AJ$3=6),0),0)
The INDEX part of the above searches for a 6 in the range ATM!$C$3:$AJ
$3.
The -- appears to create an array. Is the -- shorthand for another
function ?
Regards
You can download a free copy of Microsoft Office Compatibility Pack for
Word, Excel, and PowerPoint 2007 file formats from
http://office.microsoft.com/en-us/products/ha101686761033.aspx
Tom Jeffries
On Sat, Feb 6, 2010 at 1:19 PM, Harpreet Singh Gujral <
harpreetguj...@gmail.com> wrote:
I strongly recommend
Advanced Modelling in Finance Using Excel and VBA
Mary Jackson and Mike Staunton
Tom
On Sat, Oct 10, 2009 at 1:38 AM, summu wrote:
>
> I want to learn Financial Modeling ,Can any body help me?
>
> I need step by step tutorial or books or what ever nee
I strongly recommend
Advanced Modelling in Finance Using Excel and VBA
Mary Jackson and Mike Staunton
On Sat, Oct 10, 2009 at 1:38 AM, summu wrote:
>
> I want to learn Financial Modeling ,Can any body help me?
>
> I need step by step tutorial or books or what ever needed to learn
> Financial M
The attached provides a possible solution. If you have any questionslet me
know.
Tom
On Tue, Apr 28, 2009 at 11:19 AM, Tom Jeffries wrote:
> The attached provides a possible solution...If you have any questions let
> me know.
> Tom
>
> On Tue, Apr 28, 2009 at 8:27 AM, ronnie wr
The attached provides a possible solution...If you have any questions let me
know.
Tom
On Tue, Apr 28, 2009 at 8:27 AM, ronnie wrote:
>
> I did this much coding and i am stuck out here can you help on how to
> approach from here.
>
> Sub seating()
> Dim inputrow As Intege
Try This :
Select Case Crit_Value
Case 0
Cells(25, 1).Text = "No Order"
Case Crit_Value < 0
Cells(25, 1).Text = "Error Crit_value < 0"
Case Is < Init_Inven
Cells(25, 1).Text = "No order inventory on hand>Crit value"
Try:
LastRow = ActiveSheet.Cells.Find(What:="*", SearchDirection:=xlPrevious,
SearchOrder:=xlByRows).Row
On Fri, Apr 17, 2009 at 8:01 PM, boney wrote:
>
> I have two sheets A and B . I need to copy the columns ( A through an
> unknown number of columns ) from sheet A into sheet B starting from
>
used for the action
should contain
=Action(A15)
If you have any questions let me know.
Tom
On Fri, Apr 17, 2009 at 10:47 AM, healthandsafetysupp...@googlemail.com <
healthandsafetysupp...@googlemail.com> wrote:
>
> Hi,
>
> Im a bit stuck on a worksheet.
>
> I am making
et me know.
Tom
On Fri, Apr 10, 2009 at 9:40 PM, mother wrote:
>
> Yes, this is what I am looking for.
> I guess the X-axis is fixed and cannot dynamically adjust.
>
> Now I have to figure out how to do this with an Option (put or call).
> http://www.optiontradingpedia.com/option_t
Take a look at the attached spreadsheet. I think it does what you want. If
you have any questions let me know.
Tom Jeffries
On Fri, Apr 10, 2009 at 8:44 AM, mother wrote:
>
>
> I'm trying to figure out how to create a Simple Risk Graph (profit/
> lost diagram) like the
Attached is an updated version that handles the alphanumeric data in column
2 correctly.
Tom
On Thu, Apr 2, 2009 at 7:56 PM, Cesar Delanoval wrote:
> Tom, the formula works great except for column 2. On this column I have
> data that is alpha numeric, The data could be from 1 digit up
The attached workbook contains a macro (CvtToText) that does what you
describe. You may want to change variable FilePath to define the location
of the text file.
If you have any questions let me know.
Tom
On Wed, Apr 1, 2009 at 4:43 PM, Cesar Delanoval wrote:
>
> I need to know if anyo
This should do what you want:
Public Sub GetNonBlank()
Dim TotalRows As Integer
Dim LastCell As Integer
TotalRows = Cells.Find("*", ActiveCell.SpecialCells(xlLastCell), , ,
xlByRows, xlPrevious).row
For i = 1 To TotalRows
With ActiveSheet
LastCell = .Cells(i, .
2009 at 8:27 AM, xmux wrote:
>
> How can i manage it with the If Selection.Cells(x, 8) ??? Can u please
> explain?
>
> Thanks
>
> On 23 Mrz., 20:31, Tom Jeffries wrote:
> > An Alternative Solution:
> > Public Function IsAcct(code As String) As Boolean
> >
An Alternative Solution:
Public Function IsAcct(code As String) As Boolean
Dim Acct
Dim Found As Boolean
Acct = Array( _
"AD", "AE", "AF", "AG", "AI", "AL", "AM", "AN", "AO", _
"AQ", "AR", "AS", "AT", "AU", "AW", "AX", "AZ", "BA", _
"BB", "BD", "BE", "BF", "BG",
uot; & s2 & "." & s3 & "." & s4
End Function
s1,s2,s3 and s4 are the four values to be separated by periods.
Call as: =FMT(A1,B2, C5, E6) assuming the four numeric values are in the
respective cells.
If you have any questions let me know.
Tom
On Wed,
The attached workbook contains a possible solution. It's not elegant but
does what you want.
Tom
On Tue, Feb 17, 2009 at 4:08 AM, Pooja Sharma wrote:
> Hi All,
>
> I need a help on the Vlookup formula, for this I'm attaching a file in
> which in one worksheet there is a Ba
The atttached WorkBook starts at L4 rather than A4. If you have any
questions let me know.
Tom
On Mon, Feb 9, 2009 at 6:18 AM, Ometoon wrote:
>
> Hi Tom!
>
> Thank you very much for your file! I have only one small question:
> Is it possible that the function starts in Cell L
I am attaching a Workbook containing a macro (FmtWeekNum) that does what you
describe. If you have any questions let me know.
Tom
On Fri, Jan 30, 2009 at 5:37 AM, Ometoon wrote:
>
> Hello,
>
> I am trying to highlight the present week with a border. The
> weeknumbers are shown
The attached Workbook contains a macro (SplitTags) that splits your tags
into individual columns. If you have any problems lt me know.
Tom.
On Sun, Jan 25, 2009 at 2:07 PM, agrinshtein wrote:
>
> Hey Tom and everyone else,
>
> http://is.gd/hbjF -- here is the link to the raw data.
It is not clear what you are trying to do. Can you provide a sample of your
raw data?
Tom
On Sun, Jan 25, 2009 at 3:18 AM, agrinshtein wrote:
>
> I am importing my financial data from the internet to excel as I would
> like to view it in excel due to its powerful pivot tables.
A more general solution if you use a macro:
Function ConcatRange(r As Range) As String
Dim s As String
Dim c As Range
For Each c In r
s = s & c.Value & ","
Next
ConcatRange = Mid(s, 1, Len(s) - 1)
End Function
Tom
On Fri, Jan 23, 2009 at 2:34
Consider using the ROUND, ROUNDUP or ROUNDDOWN functions
On Thu, Jan 22, 2009 at 4:36 AM, Kamran Haider
wrote:
> Dear Group mates,
>
> Please help me on round formula as xl built in formula round the figure on
> general math rule i.e 25.5 to 26 and 25.4
> to 25 whereas i want to work this form
Take a look at the attached macro. It may do what you want.
Tom
On Tue, Jan 20, 2009 at 12:49 PM, Debasish Sahu wrote:
> hi
> I have several work books having contact details in a folder (with same
> headers). Now I want to merge all files in to one sheet. Could somebody
> plea
If all you want to do is print a few sheets from your workbook. Try the
following :
Public Sub PrintSomeSheets()
Dim FileName As String
Application.ScreenUpdating = False
FileName = "C:\Accounting\Reports\Budget.xls"
Workbooks.Open FileName, , True
With Workbooks(FileName)
2009 at 4:14 AM, Joe wrote:
>
> I have Tom, but how can I attach the spreadsheet for you to view ?
>
>
> On Jan 5, 9:53 pm, "Tom Jeffries" wrote:
> > Do you have an example of the Calendar? Describe its format in more
> detail.
> >
> >
> >
>
The best way to convert your "nasty" file is to create a macro to scan the
file and transfer the desired data to a new spreadsheet in the format you
want . Without knowing the format of the file I can't be more specific.
To create a link from PowerPoint to your Excel file.
1. If you're wor
This may help
To create a link from PowerPoint to the info in your Excel file.
1. If you're working with content on a worksheet rather than on a
chartsheet and don't want grid lines in your PowerPoint presentation, choose
Tools, Options, View and remove the checkmark next to Gridlines; then
Do you have an example of the Calendar? Describe its format in more detail.
On Mon, Jan 5, 2009 at 5:18 AM, Joe wrote:
>
> > I wonder if you can help out an absolute novice when it comes to excel
> > macros.
> > My girlfriend has sent me some homework as she has to work today and I am
> > a
I think the following does what you want:
Sub MoveData()
Dim LastRow As Integer
Dim Row As Integer
LastRow = Cells.Find("*", ActiveCell.SpecialCells(xlLastCell), , ,
xlByRows, xlPrevious).Row + 1
For Row = 1 To LastRow
Cells(Row, 2).Value = Cells(Row + 5, 1)
Cells(
provided. If you have any questions let me know.
Regards,
Tom
On Tue, Dec 30, 2008 at 2:05 AM, vijender kumar wrote:
> Hi to All,
>
> I have problem if you guys have solution then please provide me.
>
> My probelm is I have 20 or 30 folders and each folder containing 30 to 40
> excel
The attached workbook (GetJobs) shows a way to get the data you want. Use
the Worksheet_Change event to launch a subroutine to retrieve the desired
information. It is not very elegant but does appear to work. If you have
any questions let me know.
Tom
On Sat, Dec 27, 2008 at 3:00 AM, konark
Take a look at the attached workbook. I believe it does what you want.
Click the button and a tab will be created for each report and its contents
copied to it. If you have any questions let me know.
Regards,
Tom
On Thu, Dec 18, 2008 at 4:53 PM, guggd2868 wrote:
>
> Hi all
>
> I h
The attached workbook contains a macro (CombineWorksheets) that may do what
you want. If you have any questions let me know.
Tom
On Wed, Dec 24, 2008 at 8:28 AM, 2008ra...@gmail.com <2008ra...@gmail.com>wrote:
>
> hi,
>
> i have 5 sheets and columns A and B have same ti
Cells.Find(What).Row
MsgBox "Target found in row " & r
Else
MsgBox "Target was not found"
End If
End Sub
Regards,
Tom
On Thu, Dec 18, 2008 at 12:02 PM, ShellyGirl wrote:
>
> Hello, I am trying to create a macro. I would like for user to be
> able t
e)
a.WriteLine String(15, "*") & " EMPTY " & String(15, "*")
a.Close
End If
Tom
End Sub
On Tue, Dec 23, 2008 at 7:28 AM, Samir Agayev wrote:
>
> Dear Members,
>
> Is it possible to create a text file on condition?
>
Sorry , I place signature within code...
On Tue, Dec 23, 2008 at 5:27 PM, Tom Jeffries wrote:
> The following macro does what you want. Note it must be named Auto_Opento
> run automatically when the workbook is opened.
> Sub Auto_Open()
> '
> ' When Workboo
t;K1" Then
car = table(2)
ElseIf dnm = "K2" Then
car = table(1)
End If
End Function
If you still have problems please provide a more detailed explanation of
your requirements
Tom
On Thu, Dec 11, 2008 at 11:12 AM, 2008ra...@gmail.com
<2008ra...@gmail.com&g
used to hod the data for the comboBox. You probably
will want to hide it.
If you have any questions let me know.
Tom
On Sat, Dec 6, 2008 at 6:22 PM, Chitz <[EMAIL PROTECTED]> wrote:
>
> Hello Excel experts & wanna bez!!
>
> I need to create a automated tool where:
>
> 1
What you describe is best accomplished by a macro rather than a formula .
Take a look at the attached function (GetValue). If you have any
questions let me know
Tom
On Sat, Dec 6, 2008 at 3:31 PM, watmatt <[EMAIL PROTECTED]> wrote:
>
> Can you help me please? I have a bit of a s
Here's a function (TotalFee) that does what you describe. Take a look at
the attached file.
Tom
On Thu, Dec 4, 2008 at 6:26 AM, Ahmedhonest <[EMAIL PROTECTED]> wrote:
> Please find the attach file and suggest your valuable answers
>
> Expecting for a faster reply
&g
I am attaching a function (GetRate) that does what you describe. If you
have any questions let me know.
Tom
On Wed, Dec 3, 2008 at 11:25 AM, raghuveer kumar <[EMAIL PROTECTED]>wrote:
> Hi,
>
> I had a small query.
>
> I had a data like as given in below example.
>
a solution to your problem is to precede the numeric string with a single
quote ' . For example '6-2 will show the text sting 6-2 while 6-2 (without
the single quote) gives 1-Jun. Not very elegant but it seems to work.
Tom
On Mon, Dec 1, 2008 at 9:02 AM, kondaveti <[EMAIL PROT
To create an Excel add-in file, follow these steps:
1. Load the workbook that is destined to become your add-in.
2. Start the Visual Basic Editor by pressing *A**LT**+11*.
3. At the very top of the Project window, select the bold entry that
declares the name of the VBA project that is
Could you post the file in question?
Tom
On Thu, Nov 20, 2008 at 10:46 AM, macrogirl <[EMAIL PROTECTED]>wrote:
>
> I have a sub procedure written under another procedure. When I press
> F5 to run the procedure, it is not listed in the drop down menu but
> the code righ
The attached Workbook contains a macro (ColToTable) that does what you
describe. It's not elegant but appears to work. If you have any questions
let me know.
Tom
On Wed, Nov 19, 2008 at 12:43 PM, KO <[EMAIL PROTECTED]> wrote:
>
> Hey all-
>
> I have been searching ever
illustrates the above. Note that Cell D5 has a
pull-down that accepts only the allowed values.
If you have any questions let me know.
Tom
On Wed, Nov 19, 2008 at 3:03 PM, Vicent Giner <[EMAIL PROTECTED]> wrote:
>
> Hello.
>
> This is my first message to the group.
>
> My me
The attached Workbook contains a macro(SplitCol) that does what you
describe. If you have any questions let me know.
Tom
On Wed, Nov 19, 2008 at 10:13 AM, Mike <[EMAIL PROTECTED]> wrote:
>
> Hi,
> i have a data populated into a column with company name and other data
>
What specifically doesn't work?
Tom
On Wed, Nov 19, 2008 at 2:33 AM, arun p <[EMAIL PROTECTED]> wrote:
> Tom, your combineworksheets macro doesnt work.
>
> regards
>
>
>
> On Sat, Nov 15, 2008 at 8:37 PM, Tom Jeffries <[EMAIL PROTECTED]> wrote:
>
&g
Consider using a pivot table
On Mon, Nov 17, 2008 at 9:14 PM, Dean <[EMAIL PROTECTED]> wrote:
>
> I have a list of building data. Within that data, there are 15 unique
> towns. I want to know how many times a building of a certain age group
> occurs in each town. There are 13 age groups. For
I think the proper syntax is:While InputSheet.Cells(iInputRow, 2)
.Value <> ""
On Mon, Nov 17, 2008 at 12:10 PM, <[EMAIL PROTECTED]> wrote:
>
> I am trying to input a loop While/Wend with If statements in between
> but it's showing me this code as an error:
>
> While InputSheet.Cells(iIn
u have any questions let
me know.
Tom
On Sun, Nov 16, 2008 at 3:02 PM, <[EMAIL PROTECTED]> wrote:
>
> I'm trying to create a macro that will do the following:
>
> When the user changes a value or values in column 'B', the macro will
> iterate through all cells i
Assuming that the Worksheets you want to combine are in the same workbook
the attached macro CombineWorksheets will combine them into a single sheet
named "Combined". Then proceed with your pivot on the combined sheet.
Tom
On Fri, Nov 14, 2008 at 4:37 AM, arun p <[EMAIL PROT
I tried your example and it worked as it should. If you have a large number
of nested If statements consider using the Select Case construct in VBA. I
created a function cmp() included in the attached workbook that uses Case
Select to to what you want.
On Fri, Nov 14, 2008 at 10:48 AM, jmholt <[
rkbook will now contain 59 sheets 31 named JAN 1 - JAN 31 and 28
named FEB 1 - FEB 28.
There may be a maximum number of tabs that Excel allows that may be a
problem if you try to add too many tabs.
Regards
Tom
On Thu, Nov 13, 2008 at 12:17 AM, Ahmedhonest <[EMAIL PROTECTED]> wrote:
> Hello
Sorry,I am attaching a copy of the login macro with the IDs unhidden. Use
any of the names in column 1.
Tom
On Wed, Nov 12, 2008 at 11:10 PM, swamy nadan <[EMAIL PROTECTED]>wrote:
> Hi, Tom
>
>
> let me know the user name to open..
>
>
> Regards
>
> M.A. Swamin
The attached worksheet contains a macro (AddSheets) that will create a
specified number of worksheets as you describe. If you have any questions
let me know.
I am resending this message due to an email problem at my end.
Tom
On Wed, Nov 12, 2008 at 5:20 PM, Tom Jeffries <[EMAIL PROTEC
The attached worksheet contains a macro (AddSheets) that will create a
specified number of worksheets ass you describe. If you have any questions
let me know.
Tom
On Tue, Nov 11, 2008 at 7:56 AM, Ajay Varshney
<[EMAIL PROTECTED]>wrote:
> Hi,
>
> Is there any macro using which i c
I noticed you were looking for a function rather than a subroutine. The
attached file contains a function (BoldParse) that parses your strings. Use
whichever meets your needs.
Tom
On Wed, Nov 12, 2008 at 2:27 AM, atta khan <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> What i w
The attached workbook contains a macro (ParseBold) that does what you
describe. If you have any questions let me know.
On Wed, Nov 12, 2008 at 2:27 AM, atta khan <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> What i want to do is to separate BOLD text from a string by a formula or VB
> function. As
k. I also
moved your User Ids to Column 1 of the Login Tab and hid the column. Once a
correct user ID is entered switch to sheet 2 where work can proceed. If
you have any questions let me know.
Tom
On Mon, Nov 10, 2008 at 8:55 PM, TERTIUS KOSHY THOMAS <
[EMAIL PROTECTED]> wrote:
> H
heets meeting your criterion are printed. Note, that you need
to uncomment the lines in Traverse that actually do the printing to insert
the appropriate criteria. If you have any questions let me know.
Tom
On Mon, Nov 10, 2008 at 6:55 PM, Howy <[EMAIL PROTECTED]> wrote:
>
> Thanks, I&#x
I think this does what you want:
Public Sub GetNames()
Dim n As Integer
For n = 1 To ActiveWorkbook.Names.Count
Sheets("Sheet2").Cells(n, 1).Value = ActiveWorkbook.Names(n).Name
Next
End Sub
On Sun, Nov 9, 2008 at 2:04 PM, <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I have an exce
This may do what you want:
Sub Print_()
Application.ActivePrinter = "HP LaserJet" ' put in printer name
Sheets("Sheet 2").PrintOut Copies:=1
Application.ActivePrinter = "Lexmark 615"
Sheets("Sheet 3").PrintOut Copies:=1
Sheets("Sheet 4").PrintOut Copies:=1
End Sub
On Sat,
A good source of all things macro is http://excel.tips.net/
On Sat, Nov 8, 2008 at 6:16 AM, Pinku Tinku <[EMAIL PROTECTED]> wrote:
> Hello and Hi all the Clever foxes of the group,
>
>
>
> 1) This is my first Query to you all is that can any one
> suggest my an excellent site for
91 matches
Mail list logo
