cstr()

  1. B

    HELP!- VBA Code Not Work when moving rows from 1 sheet to another

    Hello All, The below code is not working when I change the criteria(line 17) from a number to a text. Can anyone help? Do i need to do anything to Line 11? I want to pick up any rows in which Column T contains the word DSM and move a range of columns(Line 20- (RawData) to columns A-E in Sheet...
  2. N

    Refresh row headers in pivot tables with vba

    Hello, I need to refresh (i.e. in this case: use the SourceName again) row headers in pivot tables with vba. I found code (probably written with a former version af Excel): Public Sub piv_kor() Dim wS As Worksheet Dim pT As PivotTable Dim pF As PivotField Dim pI As PivotItem For Each wS In...
  3. M

    Excel VBA ComboBox populate based on previous ComboBox Values

    I am trying to populate a second combobox in a userform using the values of the previous combo box using Excel 2010. The first combobox is populated using properties - rowsource - List1Values (I defined dynamic names in the Data spreadsheet). I am attempting to use the following code to populate...
  4. KG Old Wolf

    cstr() works but loop still posts as value

    All, This seems so simple and it is not (at least to me). I have a loop that reads a column of cells contains text (i.e 3640F, 88190, 88172pc). I need to just use the 5 leftmost characters and post them to another cell in the same row. The Cstr() works but the result being posted in the...

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