RE: $$Excel-Macros$$ pdf converter software code needed (able2extract)

Dear All, If any have the software to convert PDF file, please send the software. Regards, C.G.Kumar -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of ankur Sent: 23/February/2010 4:02 PM To: excel-macros Subject: $$Excel-Macros

Re: $$Excel-Macros$$ Named Ranges

Thanks for your advice. I think we deviated a bit from the topic. I m looking for a alternative referencing technique used in the macro code that I have pasted in my email. The problem is that the code uses R1C1 referencing style.can we change it? The solution provided is good to use if we don

Re: $$Excel-Macros$$ Named Ranges

There's also a .RefersTo parameter that can be called. On Wed, Feb 24, 2010 at 7:36 PM, Harpreet Singh Gujral < harpreetguj...@gmail.com> wrote: > Hi Group, > > In order to name ranges i use the following code: > > ActiveWorkbook.Names.Add Name:="Ctr1", RefersToR1C1:= _ > Strshtname & "R1

Re: $$Excel-Macros$$ Inventory

Hi Ankur, Can you send a general inventory control format in excel which can be used to manage stock of various spare parts of automobiles ? Any thing like that would help. Thanks, AJ On Sat, Feb 20, 2010 at 10:11 AM, ankur wrote: > there are numerous format of payroll and inventory > ca

Re: $$Excel-Macros$$ Named Ranges

'Named ranges are a great capability provided by Excel. You can define all sorts of named ranges in a workbook, ' but how do you access them when creating macros? This tip explains the different ways you can access those ranges. '(This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Exce

Re: $$Excel-Macros$$ Fw: Drop Down List

Thank you so Much What an idea sir ji,, Amit Jaggi - Original Message - From: Daniel To: excel-macros@googlegroups.com Sent: Wednesday, February 24, 2010 9:43 PM Subject: RE: $$Excel-Macros$$ Fw: Drop Down List Hello. Have a look at the attached file. I have

Re: $$Excel-Macros$$ Need to grab a word from a string

Dear Mike here is your solution. On Thu, Feb 25, 2010 at 8:23 AM, Mike wrote: > Hi folks, > Looking for a function(if it exists) that will grab the first letter > in a string and put it in another cell. For example: > > '12 Roosevelt Ave.' > > Some function that will grab the '12' and put it

Re: $$Excel-Macros$$ Need to grab a word from a string

Say Cell A1 is 12 Roosevelt Ave =VALUE(LEFT(A1,FIND(" ",A1,1))) Regards, Viral Pandya On Thu, Feb 25, 2010 at 8:23 AM, Mike wrote: > Hi folks, > Looking for a function(if it exists) that will grab the first letter > in a string and put it in another cell. For example: > > '12 Roosevelt Ave.'

RE: $$Excel-Macros$$ Need to grab a word from a string

Hi, Conflicting info. First you say you want to extract just the first letter, then you say you want the first 2 digits. Please clarify. But look in the Help for info on the LEFT function. It may be what you need. Regards - Dave. > Date: Wed, 24 Feb 2010 18:53:18 -0800 > Subject: $$Excel-M

$$Excel-Macros$$ Named Ranges

Hi Group, In order to name ranges i use the following code: ActiveWorkbook.Names.Add Name:="Ctr1", RefersToR1C1:= _ Strshtname & "R1C1:R2C3" It uses R1C1 referrencing, can we use the other referrencing for this code Thanks Harpreet Gujral -- --

$$Excel-Macros$$ Need to grab a word from a string

Hi folks, Looking for a function(if it exists) that will grab the first letter in a string and put it in another cell. For example: '12 Roosevelt Ave.' Some function that will grab the '12' and put it in another cell, with the original cell left over with just 'Roosevelt Ave.' I don't kno

$$Excel-Macros$$ Nova to excel

Team, Does anyone know how to export 'Name Groups' from a Nova (T1) database into an Excel spreadsheet please? Kind regards Mike Brumby <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> <><><>><> <><><><><><><>There is always a little m

RE: $$Excel-Macros$$ How to pick the last price of Each product?

Hi Abdul, Try this formula in Row 2. You can copy down for other rows. =HLOOKUP(1E+99,B2:S2,1) The 'B2:T2' range is a guess. You will have to adjust it to the 1st and last cell in your row. I've attached a sample file. Regards - Dave. Date: Wed, 24 Feb 2010 08:53:41 +0500 Subject: $$Excel-Macros

Re: $$Excel-Macros$$ Dependent drop down lists

Create Multiple Range of you data Let suppose we Have A C A D A E B F B G B H Give the Name A1:A6 MAIN SOURCE GIVE Name the B1:B3 as A GIVE Name the B4:B6 as B select the Column where you want to show main SOURCE and in sub menu Give Formula of =Indirect("Range of the data in bases o

$$Excel-Macros$$ Re: Application.commandbars

Does anybody have access to complete information on Commandbars, and all its properties. Please forward it to me Thanks Harpreet Gujral On Feb 21, 7:56 pm, Harpreet Singh Gujral wrote: > Hi, > > Can someboday help me with the commandbars? > > I am looking forward to create a custom commandbar

Re: $$Excel-Macros$$ Please help - consolidate all shets in main shet

Dear Ashish, The said file is weighting around 5.5mb even after zipping it, unable to send in this email. Provide me any other option to send the file. Thank you, On Tue, Feb 23, 2010 at 5:47 PM, saroj.32006 wrote: > Dear Ashish, > > Please find the attached file of the said query. I am sorry