property

  1. J

    Get Shape properties thru Formula

    This is probably a simple Yes/No.:laugh: Is there a formula that will get (or allow the calculation of), say, the XY coordinates of each end of a line shape? I know it can be done with macros. And, I suppose the result could be stuck into a group of cells, but that isn't elegant.
  2. J

    Show Name of property (not the value)

    All of following using VBA. I have an exercise for students to help them understand Range().Properties They use VBA to read various properties of a range and put those property values in B1:B10. For example, Range("B1").value = Range("RangeDemo").HasFormula. B1 then shows true/false as they...
  3. R

    WorksheetFunction StDev error (easy?)

    'Unable to get the StDev property of the WorkSheetFunction class' Ok guys, this error isn't too difficult (I don't think)... I have problems with my newSTDEV function when a worksheet only has one line of entered data in it. I believe it's because you can't take StDev with only one value so...
  4. A

    Excel 2010, New workbook WITHOUT property view

    My office has just upgraded to Excel 2010. When I open a new workbook it always automatically shows Property Views ribbon. How can I open without this? My IT dept doesn't know. http://files.engineering.com/getfile.aspx?folder=698ee895-f313-434d-b4b0-984dd0627a8c&file=temp_110615.bmp I hate...
  5. J

    Web query for password protected site

    Hello all, I am trying to create a macro that fetches information from a password protected site. I am getting error 438 but don't know how to fix it. At the moment, I am unable to automate the log in process. I tried checking the page's source code for the property but I'm not sure what...
  6. D

    Use For Next Loop to Append Numbers to Form Property Names

    I've created a form with Label names as follows: lblCard1 lblCard2 lblCard3 etc. I want to create a For Next loop that'll append the "next" number to the property name of a label for the purposes of changing the caption. Here's an example (of what doesn't work): Dim lblCard(i) As...

Some videos you may like

This Week's Hot Topics

  • Launch Script When Tab Is Opened
    Hello all! Is there a way to launch a script or message every time a particular tab (DATA1) is selected/opened? I know it can be done when...
  • VBA that can extract words that starts with # and ends with 2021.
    Hi Everyone, I am straggling to in searching for a vba code that will extract a string that starts with # and ends with 2021. The string has no...
  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • VLOOKUP Formula ?
    Hi i am using this below but i need to return Column C on Detailed_view. You can see ,1 this returns D, but i need to return C before D. I tried...
  • conditional formatting the whole row
    Hello This is a question solved earlier by etaf. But I am getting some problem. I need help to correct the formula as it is not working in some...
  • Vlookup in vba
    Hi, I am new with the VBA, can someone help me, I have made this macro, but the loop across files in a directory runs only in cell G13, and I...

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
Top