Re: $$Excel-Macros$$ MACRO VBA

2015-11-05 Thread Paul Schreiner
ber 5, 2015 3:21 AM Subject: $$Excel-Macros$$ MACRO VBA hi I am starting with VBA and I'd like to create a macro that group every element of a column in another one by giving them a name. for instance: Year         colour2015      blue2014      red2003     yellow2011     blue2006     red I

$$Excel-Macros$$ MACRO VBA

2015-11-05 Thread ulysse-pacome koudou
hi I am starting with VBA and I'd like to create a macro that group every element of a column in another one by giving them a name. for instance: Year colour 2015 blue 2014 red 2003 yellow 2011 blue 2006 red If the year is 2015 or 2011 the given colour have to be b

Re: $$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink

2012-03-23 Thread Raj Mahapatra
hi venkat, appreciating for your assistance.. actually i have stored some html files in a particular folder and i wants to search and hyperlink the path of that file in the sheet. Thanks & Regards On Fri, Mar 23, 2012 at 9:49 AM, Venkat CV wrote: > Hi , > > See below link.. > > http://www.pcr

Re: $$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink

2012-03-22 Thread Venkat CV
Hi , See below link.. http://www.pcreview.co.uk/forums/re-search-html-access-vba-t3992723.html *Best Regards,* *Venkat * *Chennai* * * On Thu, Mar 22, 2012 at 12:13 AM, Raj Mahapatra wrote: > hi all > > i am looking for some vba codes which will search html files (bases file > names in the sh

$$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink

2012-03-21 Thread Raj Mahapatra
hi all i am looking for some vba codes which will search html files (bases file names in the sheet) from specified locations and paste the path of the same file as hyperlink in the sheet Thanks -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. P

$$Excel-Macros$$ Macro VBA help - Dynamic Range & limit to last cell

2010-10-06 Thread DaveK
Attached is the macro code I need help with. I want to define the end of the range (to the last occupied cell) in the code. currently the range is fixed based upon the initial use of code.(I attached a listing of the code to reference). Can anyone assist? Thx in advance! Dave Sub Macro_PMT() ' '