Posts by aturnon

I need vba code to open a HTML file when i click a button in microsoft excel.

Thanks in advance

Re: Validation Below Or Above

Quote from Andy Pope

for validation on B4 use this custom formula

=AND(ISNUMBER(B4),OR(AND(B4>=-999,B4<-0.1),AND(B4>0.1,B4<=999)))

Thank you

I want to set a print area so that it is columns A:G but only sets the print area upto the last row with data in it.

I want to make a cell validated so that a user can only enter a value that is either below -0.1 or above 0.1.

This is not necessary the next but is desirable to set a maximum of 999.99 and -999.99.

Thank you in advance J

Re: Continue Finding

Yea i cud try that, thanks

Re: Continue Finding

I don't think i explained it correctly.

I type it say Mark in N3. It then looks in column B finds mark and selects the cell in column A where Mark is found in Column B.

However i want it to be able to click my button again and it'll select the next cell that has Mark in Column B. If you get what i mean

I have this vba code and i want it to carry on finding the next cell with the same value, so every time i click the button it'll find the next cell with the same value. E.g. i type in mark it'll find the first Mark, then click again it'll find the second Mark and so on

Sub Find_cust()


      If Range("N3").Value = "" Then
      MsgBox "Please enter a customer name"
      Exit Sub
      
      End If


      valueToLookFor = Range("N3").Value
      Set found = Worksheets("CD").Range("b:b").Find(valueToLookFor, LookIn:=xlValues)
      If Not found Is Nothing Then
         iRow = found.Row
         Cells(iRow, "A").Select


End If


End Sub

Re: Select Cell With Value I Type

Thanks my mistake

Re: Select Cell With Value I Type

I don't understand wheres the macro or/and how would it work

I want a macro to select the cell with i type. Like i type in cust-0001 and it selects the cell which has cust-0001. I then want it to select the cell in column C that is in the same row with that value. E.g.

Find cell in column A with value cust-0001 and then select the cell in column B in the same row.

I don't know how to tackle this in excel vba using a macro

I want to force the first letter of each cell in Column A to uppercase until it reaches a blank.

I appreciate the help in advance to your replies

Re: Select Last Cell And Fill Down

Thanks Mate

Re: Select Last Cell And Fill Down

Yea using a macro

I want to select the cell under the last cell of a particular worksheet and use the filldown function

This is the code i am tryin to use but won't work

Worksheets("CD").Range("A1").End(xlDown).Row + 1.Select
Selection.FillDown

If anyone has any ideas it would be much appreaciated.

Here is the code i am using:

Range("A:I").AdvancedFilter Action:=xlFilterCopy, CriteriaRange:=Range( _
        "O14:O15"), CopyToRange:=Worksheets("Report2).Range("A19"), Unique:=False

I am basically trying to advance filter data on worksheet "Custpercust" and i want to filter it to another worksheet, which is "Report2".

Re: Copy Until Blank

Duh i dint realise you can do that, Thank you XXXXXXX

Here is the code i am using:

Worksheets("Costpercust").Select
    Range("S:Y").Select
    Selection.Copy
    Sheets("Report2").Select
    Range("A19").Select
    Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=True, Transpose:=False

Basically S:Y is where data is advanced filtered, so i cannot pick a specific row size e.g. S1:Y2000

I want to copy data in columns S:Y until blank and then paste it A19 on another worksheet. The problem is i cant copy S:Y and paste it at A19 only at A1 i can paste it. Help would be much appreciated

Basically i have a worksheet called "Bookings".
In that worksheet the cell A3 contains a cell value, which i change often, such as B3, B4, G5, F6, etc

I want a macro that will use the value i typed in A3 as the range
so something like

Worksheets("Bookings").Range("A3.Value").

If you get what i mean. I don't know how to tackle it, i need a way to refer to a range as a value in a cell.