Hello Monty.
I was just thinking how to copy as am learning i do not have any sample file..
think starts from row 5 excluding headers. Sorry iam away from my work.
Thanks.
Thank youuuuuuuuuuuuu..
I remember this Workbook even..when you were explaning about combobox.
Private Sub Workbook_Open()
With ComboBox1
.AddItem "Excel 2003"
.AddItem "Excel 2007"
.AddItem "Excel 2010"
.AddItem "Excel 2013"
.AddItem "Excel 2016"
End With
End Sub
Monty
May be this...you are refereing to..where you can increase the rage of the list box contents.
Please confirm..Its time for me to prove am a big FAN and fallowing you.
Hello.
Wanted to create a new sheet with specific data from autofilter as of now am trying to autofilter and copy visible cells and pasting in new sheet and renaming it.
But the problem is data is keep increasing on monthly basis..Please advise.
Hey Montyyyyyyyyyy.:):):):):):):)
I was just running this file and work excellent, just a click of a button sending 70 emails with PDF..Thank you so very much.
I will ammend into my requirment.
Is it possible creating PDF and sending as attachment, we are making as BMP file and sending for 100+ email address in lotus notes and need to make it to outlook now, trying my level best with this forum.
Hello Mark.
Adding DoEvents statement just before Next codeline.
Can we use where ever we use loops same case when we have more number of line and loop running it goes not responding mode but still works, how can we make our window active..Please advise.