Search results

Dear Sir @Marc L , Thank you very much for your update & give me a little effort for me, it works as expected & now no need to manually drag. Thanks & Regards, Chirag Raval

Dear Sir @Marc L , Before time to work on this file, i will set (1 time only) total width of dataset through adjust individual column width to horizontally fit on vertical A4 paper. I already put ActiveSheet.ResetAllPageBreaks ,before your "With range(..." line. & all goes as expected...

Dear Sir @Marc L , Thank you sir, I checked, its work as expected but after some manually setting. Before, on every run this code, its force to , explicitly select whole print area (till 1st dataset to end of dataset) & set print area. so I already try to reset by put...

Dear All Experts, Again Here , but now For Horizontal Page breaks. Requirement to print 2 data sets on 1 single page. Horizontal Page break require on every 2nd occurrence of particular text on cell. Ignore Hidden Rows. For example, on some sites,I already Try below...

Dear Sir @Kenneth Hobson , Can you help in your this great helping code? Regards, Chirag Raval

Dear Sir,, Can i attatch /send 2 files same name ,but extension is different? I already create .PDF from same file, same name but just extension is .PDF. now i can't attach both file in same message , its create 2 separate mails for each file . 1 message for .xlsx file & 1 for .pdf, i wnat...

Dear Sir @vletm Thank you for your invaluable efforts to resolve this problem.. Based on all your effort & research on net... (1) I uninstalled-Apache Open Office (which have also below visual c++ redistrubutable.. (2) Re-Install Micosoft Visual c++ Redestributable (2015-2019) after download...

Dear SIr @vletm , I also check & reset-file association to open .rtf files -that seems always associate with.docx extension & as per yours... (1) Can You test backup or the real file with other computer, which 'works as normal as those would'? --That's necessary? because all runs goods on my...

Dear Sir @vletm , & Sir @Kenneth Hobson Have You updated or changed Your Excel-version? ... No are all settings same as few days ago?-Yes Have You changed ... anything ... in that code in previous days? ... anything means anything!-no just instal apache open office & Access Database engine Have...

Dear Sir @vletm & Sir @Kenneth Hobson , Can we resolve it? what need to check ? if something happen in registry? or other aspects? Regards, Chirag Raval

Dear Sir @vletm , i install & uninstall python , also uninstall pycharm (python editor), also run ccleaner can it effect those? can i repair office 2016 now if that can resolve this issue? Regards, Chirag Raval

Dear Sir @vletm , Thanks for your response.i checked there are no space extra space after (sig). I also already try to copy paste your given "should look like GetObject(sig).Range.Copy ...i also check whole path till that signature fle ..but seems its not recognize that file....since last 3...

Dear Sir @Kenneth Hobson , After Long time....your suppppper code work like a charm till now...but.... why below error shown now? i copy your code for many different situation they all work super till now... but...since yesterday... which line cause error??? Attached your invaluable...

Dear Sir @Marc L , When open Excel,Default column width =8.43, but if, Column width is 9.86 , if font is calibri , size =11, Regards, Chirag Raval

Dear Sir, Amazing ...Just Run as Desired.... And perfectly page breaks on every 50 & in multiple rows, ...Great Sir,...Thank you.. But... work only in Unique workbook..that have only module1 ...can it run through personnel.xlsb? ...if that happen, Whole thread meet the solution... Regards...

Dear Sir @Marc L , Thanks for pin point that, now I will generate new file , data in sheet1 (codename of sheet, not sheet"s name which visible to user ) , copy your code in new module in that workbook , without any modification, , generate new sheet, name it "Result", copy data of sheet 1 to...

Dear Sir @Marc L , Thanks, I already go to print preview & back to normal view to fall / flash /force to present page break objects on sheet..but , with just copy paste your code in personnel.xlsb (without any mod, just change Sub name) ...& i missed as per your instruction, now I should...

Dear Sir, @Marc L , Why Horizontal pagebreak not found? excel 2016-64 bit... Regards, Chirag Raval

Dear Sir @Marc L , I always store all success & invaluable (atleast for me) codes in personel.xlsb... many thanks for your precise effort.. Regards, Chirag Raval

Dear Sir @Marc L , Its always A4 .. Regards, Chirag Raval

Dear Sir @vletm , May be loop over array ? or dictionary? Or Evaluate? Can i Hope something like another approach.? Regards, Chirag Raval

Dearvsi Dear Sir @Marc L , Can we see result of your empirical way? If I attached my 4 co!umn source after proper Page setup? Regards, Chirag Raval

Dear Sir @vletm , Just Amazing... As Require, ..Many Thanks & appreciate your invaluable effort.. Now i have 2 style for distribute data... Though , i already update in your code about Application.Calculation = xlCalculationAutomatic,Application.EnableEvents =false,Application.ScreenUpdating...

Dear Sir @Marc L sorry to mention above about your code effort , can i test your procedure? if you don't mine, can i learn another as your way.? please . Regards, Chirag Raval

Dear Sir @vletm , please forgot page setup, i manually adjust it , & as per just require splitting as required columns sets/groups ...& Thank you for your working code. its work like a charm ... it is splitting data as per required column groups/sets but it distribute serialized data in...