dear sir,
Thanks for replying . it is selected page by page , but i need
select the print areaupto end of row.
Thanks with
Mothilal
On Sun, Aug 18, 2013 at 8:24 PM, Basole wrote:
> Try this ..
>
> Sub ActivAreaPrint()
> 'defines the print area as selected cells
> ActiveShe
Try to add this
Dim FSO as Object
Then replace your line code to :
Set FSO = CreateObject("Scripting.FileSystemObject")
On 19-08-2013 5:38, Indrajit $nai wrote:
Hi All,
Kindly find attached the macro based data collection file.
But when I am running the macro it's showing the some error. K
Hi,
Please elaborate some more
"OUTPUT REQUIRED" with any specific value or just group concatenate, if
any specific value please mention
please explain role of "CODES" or "Text" column
.
Enjoy
Team XLS
On Sun, Aug 18, 2013 at 9:32 PM, Rashid Khan wrote:
> Hello Al
Hello All,
I am attaching a sample of my problem.
I need to do Vlookup from a Range which has Codes in Col A and Text in Col
B.
I want to have the output required (highlighted in Yellow) on Col D based
on the Answers Col C.
My problem is that the Codes are delimited with ].
I do not want to separ
Try this ..
Sub ActivAreaPrint()
'defines the print area as selected cells
ActiveSheet.UsedRange.Select
ActiveSheet.PageSetup.PrintArea = Selection.Address
'ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
' IgnorePrintAreas:=False
End Sub
Em domingo, 18 de agos
Dear Any one,
i want change the print area based on datas.
some time 10 rows , 20 rows , 40 rows
--
*J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex
:Otteri, Vellore-2*
--
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) ! Joi
