errorcount

Hello All, I have a VBA script that takes a spreadsheet, saves it, then sends it as an attatchment in an email. However, sometimes the internet drops temporarily, so I'd like it to attempt to resend a few times before failing. I've come up with this: Sub email() Dim Msg As Object Dim...

OK, so all of this code is working for me, but I am wondering, and wanting to learn, if there are better or more efficient ways of doing the things I have in the below. I am not experiencing slow processing or anything like that now, just trying to learn as I go here. I know there is a lot of...

Hi, can anyone recommend a better way of writing the code below please to eliminate the need for multiple loops. Sub MaterialThreshold() Dim DataSht As Worksheet Dim MaterialRange As Range Dim MaterialCheck As Integer Dim ErrorCount As Integer Dim lr As Long Set...

I have a routine that, amongst other things, alters some cell values that in turn determine the content of a series of charts. Each time the charts are changed, the routine copies the chart and pastes it as a picture into another worksheet. I am 99% certain the code is sound but, for some...