thoughts

  1. N

    Password Protecting Worksheet from Viewing or Alternatives

    Is it possible to have multiple people share the same workbook with different permissions? Let's say everyone has access to the workbook file, but they have to have a passcode to view a certain tab? OR If you create the spreadsheet tabs to be very hidden, is it possible that the person who...
  2. F

    VBA range not recognized

    Not sure what has happened here or what I may have done, but what I'm typing in VBA the range is not recognized. Any thoughts as to why? Sub TestThis() range("A1").CurrentRegion End Sub Notice the range does not capitatlize.
  3. I

    Using a variable in a formula

    I've seen a similar question to the append with the heading of "Using a variable in a formula", but I can't fine the correct syntax for my particular problem which is as follows: =DATE(YEAR(summary_start_date)+1,MONTH(summary_start_date),DAY(summary_start_date)) I want to change the + part...
  4. R

    Total Item Count

    I want to match "Order IDs" and add the "sku items" for a total kit count. Thoughts? Thanks R. Turner
  5. jackfox68

    If Statement with two concatenates

    The bold underlined formula below is equating to 9.63 for the selected fields, which should default to the second concatenate, but for some reason it is defaulting to the first concatenate. Any thoughts on why...
  6. B

    How should I replace these words in brackets and the word before it?

    I have multiple text strings containing A(a), B(b), C(c), etc. A and a are related over and thousands of these are in one sheet. I want to replace A(a) with a and B(b) with b, so on. Any thoughts please? EX: Optimizer Mode(OM) -> OM Home Snoop(HS) -> HS
  7. L

    Frustration level building - any thoughts?

    I have had these lines of code in a program for two years. Sheets("ShiftReport").Select Range("B2").Select ActiveCell.FormulaR1C1 = CDate(frmShiftOnDuty.dtpShiftDate.value) It has worked without any issues, in fact this very section of the code ran yesterday. No code changes...
  8. B

    Increase VBA performance using compiled DLL files

    Has anyone ever given this a try to see if this truly does speed up your code vs running functions natively: https://analystcave.com/vba-compiler-add-in-to-vb-net/ Curious of everyones thoughts. Seems like an interesting concept if this is true that DLLs would run quicker.
  9. D

    Countifs Help needed

    I'm sure this has been asked before I need to do a countifs > or = one cell then < or = another cell and and third crietera equals "Yes" This is on office 365 excel when I put the expresion into the cell it just shows the equation. =COUNTIFS(Input!A:A,(">="(Output!C1)),Input!E:E,"Yes") I have...
  10. L

    Macro to Put Several Rows Into One

    Hi! I am looking for a macro to put several rows of typed wording into one row of text. I copied a closed captioning transcript from a video into excel and it puts the entire script in short sections in several rows. I am hoping to be able to easiely condense it to then copy it into Word...
  11. P

    If Statement Copied Down Row

    Hey all, Seems easy but I can't quite get it all together. I'm looking for a way to have this vba used in row J only if there is text in row B. Sub Test1() If (Range("I6").Value = Range("I2").Value Then Range("J6").Value = "Y" End If End Sub Basically having 2 cells (I6 and I2) checked if...
  12. M

    I cell conains then return 3 cells backwards exclude Duplicates formula needed

    Hello all i hope your sunday is well I have a table that in column E i have 3300, 2220, 1300, and 2000 what i need to get is... iF E contains 3300 then REturn Range B once ie. B C D E...
  13. M

    Multiply time by hours

    Hi everyone, I am trying to multiply time by hours. For example 4:00 am x 5 (hours). The result should be 9:00 am, but i can't find a way to get that. Any thoughts? Thanks, Mark
  14. B

    Sort leading to debug error... any thoughts?

    I have the following code working as part of a macro without any issue... of course, when I get to my client, I get a debug error... The topRow and botRow variables are storing numbers and in debug mode, when I hover over them, the correct numbers are showing. Any thoughts on a better way to...
  15. N

    5 largest sums and corresponding value

    Hi. I need help. Example Data in column A - C. Desired Results E-F. I am looking to return the 5 largest sums based on a column and return the corresponding value. Thoughts? <tbody> A B C D E F 1 FL 200 MN 700 2 TX 200 CO 500 3 FL 100 FL 400 4 FL 100 TX 400 5 MN 400 CA 200 6...
  16. M

    Which is less "resource intensive" - "Clear Shape With Text" (ie rectangle) versus "TextBox"

    I have a huge document with tons of these. And I always decide randomly which I will use on a given day. But I bet one of them takes up less space... thoughts? MC
  17. R

    INdex with part of the range

    I am trying to build an Index formula. I have the first part of the range, can I use address to get the rest of the range? so I have A1 to start so I am thinking index(A1: and then the address function to fill in the second part of the range...
  18. M

    VBA Duplex Print out

    Hi everyone, I have been working with this basic macro the last few days, and you guys have been amazing. I just have one last question on this. It will print the first two sheets, but I can't get it to print them Duplex. I tried adjusting the page settings and printer setting, but this...
  19. B

    formula question

    hello in column A i have a name that appears as Lawrence_Harris in Column B i would like it to appear as Harris, Lawrence any thoughts on how i could do this ty
  20. J

    Networkdays odd behavior

    Cell G10 = 4/10/2018 Cell L10 = 4/9/2018 (It is ok to have negative days in our business) M10 = =NETWORKDAYS(G10,L10)-1 The answer is get is -3. Most of my rows are correct, but i see a few of this type issue. Thoughts?

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