Re: $$Excel-Macros$$ Re: Print VBA code

Dear Kavita Can you give me Proper full Code then I put it excel & run it only.Bcos I am VBA learner only.I am unfamiliar about VBA Coding. Regards Amar On Fri, Apr 19, 2013 at 11:12 AM, kavita ahuja wrote: > Hi Amar, > > You can use the below code to set print area and take print in excel sheet

Re: $$Excel-Macros$$ Project Work

Hi Sathish, Please share if any project related to excel without complex macros. I m very much comfortable with the excel. Would be thankful to you if you do so.. -- Thanks & Regards, Sanjay Soni 930366 On Sat, Oct 29, 2011 at 1:19 AM, satish wrote: > Dear All, > > I am

$$Excel-Macros$$ Re: Print VBA code

Hi Amar, You can use the below code to set print area and take print in excel sheet Sheet1.PageSetup.PrintArea = "A1:D10" Sheet1.PrintOut Thanks Kavita On Thursday, April 18, 2013 7:58:54 PM UTC+5:30, amar takale wrote: > > Dear Experts team > Here I required Print command for select data.I crea

$$Excel-Macros$$ Re: Print VBA code

Hi Amar, You can use the below code to set print area and take print in excel sheet Sheet1.PageSetup.PrintArea = "A1:D10" Sheet1.PrintOut Thanks Kavita On Thursday, April 18, 2013 7:58:54 PM UTC+5:30, amar takale wrote: > > Dear Experts team > Here I required Print command for select data.I crea

$$Excel-Macros$$ Re: Sample Feasibility Report

Hi Manish, I have come across this post of yours as I was searching for example feasibility reports on google, I hope you dont mind me contacting you. I also, need to find a template for a project feasibility for a single building development. I was wondering if you had any replies to this post

Re: $$Excel-Macros$$ data range failed to refresh from local html file

Can you share the file? On Fri, Apr 19, 2013 at 4:03 AM, John Rodgers wrote: > > > hello > I have an excel 2007 workbook, which contains a number of external data > ranges. The query definition for these external data ranges is the local > path to an html file (eg, file:///D:/localfiles/filenam

$$Excel-Macros$$ data range failed to refresh from local html file

hello I have an excel 2007 workbook, which contains a number of external data ranges. The query definition for these external data ranges is the local path to an html file (eg, file:///D:/localfiles/filename.html). Each html files contains a data table. This works perfectly most of the time

$$Excel-Macros$$ Re: New Web Query get data from existing open IE Browser instead of opening new browser window

I have this exact same problem. I can run the macro just fine 7 or 8 times and then it no longer imports the data from the site. Did you ever figure out how to correct the macro or in the alternative, get the macro to extract the data from the webpage after you manually logged in? Thanks On T

$$Excel-Macros$$ Re: Required Macro for unique no

Hi, Use dictionary to take out unique items by adding into dictionary key and then print that from dictionary to the range of unique items. remove duplicates is good option too but in excel older versions,there is no such option,so dictionary can work for all. On Thursday, March 14, 2013 4:47:13

Re: $$Excel-Macros$$ Re: Same macro for multiple sheets

Thanks Prince. It's working fine. Regards Pravin. On Thu, Apr 18, 2013 at 11:55 AM, Prince wrote: > Hi Pravin, > > You may use this > > Public Sub Protect_Unprotect() > Dim wks As Worksheet > For Each wks In ThisWorkbook.Worksheets > With wks > If g_blnUpdate = True Then >

Re: $$Excel-Macros$$ Same macro for multiple sheets

Thanks Vaibhav. It's working fine. Regards Pravin. On Thu, Apr 18, 2013 at 12:14 PM, VBA VABZ wrote: > hi > > Since you restricting to specific sheet it doesnt work.. > > > Try dis: > > Public g_blnUpdate As Boolean > > Public Sub Protect_Unprotect() > 'With ThisWorkbook.Worksheets("Sheet1") >

$$Excel-Macros$$ Re: Neee Arrayformula help

Find below link for solution: http://www.excelfox.com/forum/f2/need-array-formula-help-912/ On Thursday, 18 April 2013 13:40:19 UTC+5:30, Dhaval Shah wrote: > > Excel experts > > i want Array Formula help in attech sheet by help of Lalitji i made 50 % > achivable > > pls help > > Thanks > > D

Re: FW: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Find below link for solution: http://www.excelfox.com/forum/f2/need-array-formula-help-912/ On Thursday, 18 April 2013 10:50:04 UTC+5:30, Dhaval Shah wrote: > > > > Hello Lalitji, > > Thanks for you formula > sir i modified with formula littel bit now its not working actually while > i run fo

$$Excel-Macros$$ Is there any option or code to print all open browsers.

Dear Expert, Is there any option or code to print all open browsers. Lakshman Prasad -- 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 conc

$$Excel-Macros$$ Re: Formulate a cell holding the last input data

OK solved at the end. thanks a lot! On Friday, April 12, 2013 9:51:34 AM UTC+2, Mateo wrote: > > Hi there, > > One small question: > > I recently got a document scanner that scans the values of name, surname, > type of document and number of document. > > This data is automatically entered in an