0.0px

  1. T

    Ascending Table With VBA Macro's

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545; min-height: 14.0px}</style> am trying to create an “Ascending Table” with the newest Row added to the...
  2. H

    Save Button name in a variable

    In my procedure I save the value of a lookup data item as the name of a button. ie. member = Worksheets("Current Members").Cells(c, 1) <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff}span.s1 {color...
  3. F

    Sum Up Cells That Contain The Letter "D" - Not SUMIF

    Hello All, I have a simple data set with two columns shown below. The first column contains an amount. The second column has a corresponding value that can either be "D", "R", "S", or any combination of the three letters. I am looking for a formula that can sum up the values where the second...
  4. J

    easy way to remove all letters?

    hi i have cells that look like this - what is the fastest way to remove all letters with out using find & remove one letter at a time? thanks in advance so much for your help =) happy friday!!!! <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1...
  5. H

    Cannot get code to save file as PDF - get Run-time error '1004'

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #000000 ; background-color: #ffffff }p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #008f00 ; background-color: #ffffff }p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo...
  6. W

    Rounding a number to the nearest 5 or 9

    Hi all, I am trying to work out a formula that will round a number to the nearest 5 or 9. For example: 656 goes to 655 681 goes to 679 684 goes to 685 723 goes to 725 780 goes to 779 809 stays at 809 837 goes to 839 970 goes to 969 etc. I have this formula currently: <style...
  7. H

    Run-time error '9': Subscript out of range

    I get the "Run-time error '9': Subscript out of range" error when running my macro from a Button assigned to my macro, but if I run my macro from the ribbon it works fine. (When I debug, it says the problem is with the "LastRow =" line. Don't understand why. Table256 is the only table and only...
  8. P

    Variable with offset

    Hi All, I have a vba code, can't figure out what's wrong, I'm trying to download with query web tables. What I want is: entry some share names in cells, (the share names are the only variables in the weblinks, with concatenate equation I have the right links in cells) and I expect to get back...
  9. A

    Macro Help - Copying/Summing/Averaging data from a Master Sheet to Various Months.

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; min-height: 13.0px}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Menlo; color: #011993}span.s1 {color: #011993}span.s2 {color: #000000}</style>Help...
  10. D

    Need to remove Date from Strings in Excel

    Hello All, I have data in following format: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}</style>shrestha.prakhar77@gmail.com2017-07-31 05:08:37 I need to remove data & time. I need email address only. How do I do this? Thank...
  11. J

    find within a cell

    hi! in a cell i have text that loos like this <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}</style><style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid...
  12. A

    SUMIF formula question

    It's been a while since I've used excel and I'm struggling with a basic formula. Can you help. Column C 9:22 has Y or N Column F 9:22 has numbers I want to count IF there is a Y in column C I tried <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'...
  13. E

    Convert date format?

    How do you convert this date format: 2017-03-18 To this: 03-18-2017 Any help is appreciated.<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}</style>
  14. J

    sumifs using list of cells as critera

    As opposed to doing something like this: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 14.0px 'Helvetica Neue'; color: #323333 ; -webkit-text-stroke: #323333 }span.s1 {font-kerning: none}</style>=sumifs(C:C,B:B,"<>fbk",B:B,"<>ofb") I would like to basically do something...
  15. J

    formula to find the lowest number?

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica; min-height: 13.0px}table.t1 {border-collapse...
  16. R

    Can you "freeze" relative reference?

    I’m trying to do something that seems as it would be fairly simple, but can’t figure out how to do it. The challenge can be abstracted to a two row spreadsheet: A B C D E F G H I J A B C Row 1 is constants, A, B, C….J Row 2 is only three columns and the cell values are equal to the cell...
  17. L

    Combining 3 macros into one

    Would it be possible to combine the following two macros into a single macro? Thanks in advance. Sub DelRows() Application.ScreenUpdating = False Dim LastRow As Long LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row Range("A1:A" &...
  18. K

    If statement combined with VLOOKUP to return specific text?

    Hi, everyone, I'm using a VLOOKUP to determine whether students are listed on a separate sheet which shows that they have a district laptop checked out to them. The VLOOKUP is working fine by itself: <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida...
  19. J

    VBA saving workbook creates null bytes?

    This may be a python question, not sure. I am using the following vba code to create and save a new workbook with information from the first. Range("u3", Range("u3").End(xlToLeft).End(xlDown)).Copy ' copy some data from open workbook Set dealbook =...
  20. C

    Ignoring blank cells to average.

    I am trying to average a range of cells that represent a rating (Column B) to interview question responses (Column C). The ratings are 0-5 (0-V Bad, 5-V Good) As some interview questions won't be asked the rating will be zero, but could also be zero if the interviewer rates the answer as 'very...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top