Search:
Type: Posts; User: Merton
Search:
Search took 0.02 seconds.
-
This job is would be better handled by a database than a spreadsheet. Consider using Access or another simple database program.
-
Of course You are right about the actual work being done in this question.
I (admittedly reading between the lines) took this as coming from someone looking to learn VBA, not really how to perform a...
-
I assume it's part of a larger program. Or I did his homework for him.
-
There are many problems with your code.
Lets go through it line by line.
Dim r1, r2, r3 As Integer
Here you are telling Excel that you are going to be using r1, r2, and r3 as Variables which...
-
The problem is that the purpose of
On Error Resume Next
is to ignore the error and continue. It does this by setting Err.Number = 0.
You need to use On Error Goto
Like this
Sub MySub
For...
-
Looks like you are moving down a row after you check if it is Yesterday.
Then you are hitting the loop.
if the new row is Yesterday then the loop ends.
to fix this, start a row higher and move...
-
The first thing that stands out to me is you are setting myCheck equal to ActiveCell.Value but comparing it to just ActiveCell. depending on how those numbers get to the sheet it could give...
-
That is an awfully vague question and it doesn't sound like something you would be doing in VBA, Probably VB6.
if I understand from you title you want something like this.
If Left(YourString,3) =...
-
try this
If Right(ActiveCell.Value, 3) = " ST" Then
ActiveCell.value = ActiveCell.Value & "REET"
End If
|
Click Here to Expand Forum to Full Width
|