Hey paul i really love the way of your coding.
Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, November 27, 2014 2:57:09 PM UTC+5:30, shrini wrote:
>
> Dear All
> Please find below macro.
> Pr
On a worksheet I have two listboxes; ListBox1 and ListBox3. Dependant upon
what is selected in ListBox1...it will automatically enter the appropriate
range into the ListFillRange of ListBox3:
Private Sub ListBox1_Click()
With ListBox3
.ListFillRange = Sheets(2).Range("T30")
.S
Dear Shrini,
As Anil implied, the problem with your macro is with the "overhead" with
copying the data.
When you use:
Sheets("Blends Procesed").UsedRange.Copy Destination:=ws1.Range("a1")
not only are you copying the data, but you're copying all of the formatting too.
Not only that, you are co
The main problem which i found is copying the formulas which is of no use
try this line
selection.copy ws1.range("A1").pastespecial paste:=xlpastevalues only .
avoid unnecessary formulas which you deleting after pasting it.
Second this try to make this sheet in new sheet. may be some corrrupt
