Re: $$Excel-Macros$$ personal macro workbook

Thank you very much for your help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, l

Re: $$Excel-Macros$$ Shortening an Excel Sheet

Select the upper left corner of the worksheet. Above row 1 and the the left of column A. This will select the entire worksheet. Right click any of the row numbers, then select unhide. On Mon, Feb 22, 2016 at 4:53 PM, wrote: > Dear Experts: > > See the "Input" tab in the atttached workbook. > Do

Re: $$Excel-Macros$$ System Date Problem ?

Your earlier description/expectation seems faulty:Looking at the .csv file, the first 26 records are CLEARLY not between October 2015 and February 2016.the rest seem to be in month/day/year format:2001-02-16 2001-04-16 2001-06-16 2001-08-16 2001-10-16 2001-12-16 2002-02-16 2002-04-16 2002-06-16 2

Re: $$Excel-Macros$$ System Date Problem ?

I understand Paul. PSA csv file. Thanks. On Monday, 22 February 2016 08:40:54 UTC-5, Paul Schreiner wrote: > > It'll be difficult to guess the issue without seeing the original > (unconverted) data. > Can you try importing it as "text" or even saving it as an ASCII file > without ever bringin

Re: $$Excel-Macros$$ personal macro workbook

What I would do is:1) Export each of the macro modules in this workbook.2) Record a macro, selecting to store it in your Personal macro workbook.  This will create a "hidden" workbook in the default "startup" folder.  So, it won't show up as an open workbook in Excel, but you'll see it  in VBA.3

$$Excel-Macros$$ personal macro workbook

how do i convert my attach workbook into personal macro workbook because i want to apply the shortcut key created with this macro in all the open macro. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Client in Woodridge, IL need Oracle PLM Solution Architect

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title:* Oracle PLM Solution Architect *Duration: *2+ months *Location: *Woodridge, IL JD:- *The candidate for the above-captioned position should exhibit the following requirements:-* This dedicated ind

$$Excel-Macros$$ Client in Framingham, MA need Security Engineer

Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title:** Security Engineer* *Duration: **9+ months* *Location: **Framingham, MA* *CTH after 6 months* · 3-5 Yrs of Security Domain experience, with secure systems environment experience (Networ

Re: $$Excel-Macros$$ overflow error issue

What is your "issue"?Your subject says "overflow error issue".Where/when does this occur? How many rows are in your data?(Integer data types only allow for a maximum  value of 32,768.If your maximum row is larger, then use: dim i as long dim lrow as long)Paul--

Re: $$Excel-Macros$$ System Date Problem ?

It'll be difficult to guess the issue without seeing the original (unconverted) data.Can you try importing it as "text" or even saving it as an ASCII file without ever bringing it to Excel? Also, the problem is that what *I* see when I open the file may not be what YOU see.since my7 default date

Re: $$Excel-Macros$$ Re: VBA Code for Create Name Range

Dear Mandeep pls help me on this issue On Fri, Feb 19, 2016 at 6:33 PM, amar takale wrote: > Pls look in this issue > > -- Forwarded message -- > From: amar takale > Date: Thu, Feb 18, 2016 at 5:55 PM > Subject: Re: $$Excel-Macros$$ Re: VBA Code for Create Name Range > To: exc

$$Excel-Macros$$ Re: overflow error issue

> > Will you please let me know why you're not using a simple vlookup >> function,index match for the same it would be more faster than this to >> search using find method one by one, while defining the value to integer it >> doesn't matter how many rows of data you have 1 to 5 lac it will work

Re: $$Excel-Macros$$ Hide Bookmarks using VBA

Hi Team, I got the solution. On Mon, Feb 22, 2016 at 3:18 PM, XL Macros wrote: > Hi, > > When i click on Button in Excel it should open the url ( > http://www.techonthenet.com/) in internet explorer and browser should not > contain any bookmarks (i.e all the bookmarks should be hidden) > > How

Re: $$Excel-Macros$$ copy paste issue from one sheet to another

Hi Sky, Thank you very much for your help. Cheers On Monday, 22 February 2016 02:46:46 UTC+8, sk.yadav7186 wrote: > > check it...maybe this is helpful...because i m also learner :-) > > On Fri, Feb 19, 2016 at 11:43 AM, Kat > > wrote: > >> Hi guys, >> >> I would like to copy paste entire row

$$Excel-Macros$$ Hide Bookmarks using VBA

Hi, When i click on Button in Excel it should open the url ( http://www.techonthenet.com/) in internet explorer and browser should not contain any bookmarks (i.e all the bookmarks should be hidden) How to do above task with VBA ? Regards, Karthik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Exc

$$Excel-Macros$$ Re: overflow error issue

Hi Mandeep, I have defined the variable to long for the whole program and it takes very long time for running. Also, for the code below, if I use integer, I will get overflow error. If I change variable to long, I will get application-defined or object-defined error. Can you help me on this is