ws.usedrange.value

  1. R

    Remove formula only visible cells

    Hello, I basically use below code to remove formula for the entire sheets. But is anyone happen to know if we could have a VBA code to remove formula only the selected visible cells ? Sometimes I need to keep some formula by hiding or filter it out. Sub Removeformu() Dim ws As...
  2. H

    Vba code, copy without macro or formula

    Hi there, New to VBA, I have a basic VBA code to create a new workbook without Macros or formulas. There are 2 additional I would like to add but I am struggling with. 1 - Same execution, but Cells F47,H47 and J47 to keep active formulas (these are SUM formulas id like to keep) 2 - Can the...
  3. A

    delete some sheets of new workbook

    How can I delete some sheets from the new generated workbook if I am using the following code : Sub SaveAsValues() Dim ws As Worksheet For Each ws In Worksheets ws.UsedRange.Value = ws.UsedRange.Value Next ws ThisWorkbook.SaveAs "D:\LM - " & Format(Date, "dd mmmm...
  4. A

    Error 400

    Hi to all .. I want to know what is the problem with me in this code ?? because not accepted to run (error 400) Sub SaveAsValues() Dim ws As Worksheet For Each ws In Worksheets ws.UsedRange = ws.UsedRange.Value Next ws ThisWorkbook.SaveAs "Z:\Collateral...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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