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,

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

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

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

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

$$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

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

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

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$$

$$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

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

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

$$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

$$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