suggest

  1. V

    Column name defined, want to call by that name in code

    I have quick question.. Hi All, I have define name to entire column. Now while doing code, I want to write in a code like this.. instead of wk1.Range("G1:G" & LR).Copy I want it like this.. wk1.Range(cExpirationDate).Copy Please suggest..
  2. R

    "go to" Dropbox unexpectedly appears

    I am writing a large programme - far too big to post - and, after it runs through two or three reiterations, it starts to put a standard "Go To" Dropbox up. I have no idea what is causing it - there is nothing in my code calling for that to happen. Please can anyone suggest what might be happening?
  3. S

    value of text in a cell in numbers

    Hi, I am working on a project wherein we have assigned value to all 26 characters of alphabets e.g a=1, b=1. Requirement:- As i write some word (not letter) in the cell , it should give the value of word in any other cell. Since i am not a VBA user, request you to suggest...
  4. V

    Need Advise or Help to Handle Mail Tracker

    Hi Team, Good Morning!! Please help me to track outlook email or suggest me if you have any macro present already. I
  5. G

    Need to find Unmatched Records more than one column

    Hello guys Am trying to find mismatches (more than one column) from Table A vs Table B (60-90k records) Please suggest easy way (excel or access) Posted in Excel forum too: https://www.mrexcel.com/forum/excel-questions/1035443-how-find-out-mismatching-records-more-than-one-column.html
  6. kelly mort

    Auto completion in textbox

    Hello all I have a challenge here: I want my textbox to behave in such a way that when I start to enter data in it, it should look at a range in a worksheet and then suggest words or names as I type the letters. So say I have a name "Kelly" in that range, when I start to type "K" , it should...
  7. A

    How to extract /look up pictures from one sheet to the other sheet ?

    Hi, I have two sheets in workbook(excel), i want to get picture from sheet 1 to sheet 2. Please suggest me few functions/formulas to be used. thanks in advance.
    • Aditi
    • Thread
    • advance functions/formulas picture sheet suggest
    • Replies: 0
    • Forum: Excel Questions
  8. akhendre88

    Getting Error in Application.WorksheetFunction

    I am trying to use Application.WorksheetFunction But getting an error "Object doesn't support this property or Method" Below is my code Sub test() Dim a As String Dim b As Long, c As Long a = "This is testing" c = Application.WorksheetFunction.Find("is", a) MsgBox c End Sub Please suggest
  9. A

    Formula Required to Sum only positive values

    Hi Experts, In a sheet, I have a column which contains + and - values. I want to sum only + values. Can you please suggest formula for that. Thanks

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