Search:

Type: Posts; User: eaykan; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: VBA Query - Can you point me in the right direction please

    Michael, thanks for your input and replies. Peter solved my issue. Have a good week.
  2. Re: VBA Query - Can you point me in the right direction please

    Thank you Peter, this works perfectly! Much appreciated. Have a good week.
  3. Re: VBA Query - Can you point me in the right direction please

    thanks for your reply Michael. you are correct = the data/format of the tables are the right way around. The post should have read:

    "I have a spreadsheet consisting of the following sheets...
  4. Re: Index matching multiple inputs and returning multiple results

    Svendiamond thanks for the formula- i've been searching high and low for an example like this. Thanks
  5. VBA Query - Can you point me in the right direction please

    Hi all,

    I am trying to get my head around how to start coding the following spreadsheet presented below in excel 2013. If someone could point me in the right direction as to what to look at or...
  6. Re: Make Cell blank if value is zero! Adding IF Statements to Code

    Any ideas on a way to remove all the conditional formating in cells that have a zero value in them?
  7. Re: Make Cell blank if value is zero! Adding IF Statements to Code

    the code is horribly slow...any ideas on how to speed it up?
  8. Re: Make Cell blank if value is zero! Adding IF Statements to Code

    Solved! Code is below:

    Sub Module2()
    Range("D15:XFD15" & lastrow).Formula = "=D13-D14"
    For Each cell In Range("D15:XFD15")
    If cell.Value = "0" Then cell.Clear
    Next
    End Sub
  9. Make Cell blank if value is zero! Adding IF Statements to Code

    I am trying to make cells in a row subtract the two cells in the above to rows from each other (A1 - A2 = A3 ) using the below diagram.

    THE code is as follows:

    Sub Module2()
    Range("A3:B3" &...
  10. Replies
    0
    Views
    95

    Macro Help: Trouble defining a range

    I am trying to define a range for the below code but It seems to be bringing me to the very last column of data in my spread sheet.

    I am trying to copy the formula across (subtract formula) from...
  11. Help Please! Macro to Copy formula across cells in one row!

    Hi,

    I am trying to create a macro to (when run) go through all the values starting in Column c in rows 3 & 4 (spreadsheet outline below) and subtract them from each other and populate row 5, then...
  12. Replies
    1
    Views
    125

    Re: Conditional Formatting VBA Help - please!

    Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Dim rnArea As Range
    Dim rnCell As Range
    Set rnArea = Range("A9:AT147")
    For Each rnCell In rnArea
    With rnCell
    If Not...
  13. Replies
    1
    Views
    125

    Conditional Formatting VBA Help - please!

    Hi

    could someone show me how to edit this code to pick up the values based on rows and change the cell colors based on number ranges (i.e. yellow if number range is between 0-10, red if number is...
  14. Re: Conditional formating - Colour scheme (7 colours) & Rows with varying Min & max points

    Thanks in advance
  15. Conditional formating - Colour scheme (7 colours) & Rows with varying Min & max points

    Hi all,

    Newby to the VBA world and am trying to wrap my head around a problem...Hopefully someone can point me in the right direction.

    Firstly, I have a dataset that spans from Jan 2003 to...
Results 1 to 15 of 15