SpreadsheetWeb
  • Features
  • Pricing
  • Blog
  • Customers
  • Try For Free
  • Sign In
    • Legacy Platform
    • SpreadsheetWeb Hub
Select Page
How to remove characters in Excel using VBA

How to remove characters in Excel using VBA

by Ilker | Oct 12, 2018 | Excel Macros, Excel Tips & Tricks

You can remove characters by replacing a character with an empty string (“”). Although you can do this by going through all such cells in a selection or specified range using Find & Replace, in this article we’re going to show you how to remove...
How to have Excel convert formula to value using VBA

How to have Excel convert formula to value using VBA

by Ilker | Oct 11, 2018 | Excel Macros, Excel Tips & Tricks

Printing values instead of the formulas themselves can help protect your IP or prevent users from changing them. In this article, we’re going to show you how to have Excel convert formula to value using VBA.   How to have Excel convert formula to value We...
How to delete all named ranges with #REF Excel errors using VBA

How to delete all named ranges with #REF Excel errors using VBA

by Ilker | Oct 11, 2018 | Excel Macros, Excel Tips & Tricks

Named ranges with #REF! error occur when there is a ‘reference’ error. This usually happens when the cell or range itself is removed. For example, if there is a named range that refers  to cells in Sheet1!B3 and you delete an entire row, column, or...
How to compare two rows in Excel using VBA

How to compare two rows in Excel using VBA

by Ilker | Oct 10, 2018 | Excel Macros, Excel Tips & Tricks

Comparing data row by row manually can be a tedious process if done manually. Let us show you how to compare two rows in Excel using VBA and automate this process.   How to compare two rows in Excel using VBA VBA has a built in function called StrComp that can...
How to compare two columns in Excel using VBA

How to compare two columns in Excel using VBA

by Ilker | Oct 10, 2018 | Excel Macros, Excel Tips & Tricks

Comparing columns of data manually is not a realistic approach when working with large data sets. Let us show you how to compare two columns in Excel using VBA and automate this process.   How to Compare two Columns in Excel VBA has a built in function called ...
How to highlight misspelled cells in Excel using VBA

How to highlight misspelled cells in Excel using VBA

by Ilker | Oct 9, 2018 | Excel Macros, Excel Tips & Tricks

Excel doesn't do as good of a job as some text editors when it comes to spellchecking, and we know how frustrating this can be. Let us show you how to highlight misspelled cells in Excel using VBA. Spelling check feature has been a staple in Microsoft Office products...
How to display cell formulas in Excel that contain errors using VBA

How to display cell formulas in Excel that contain errors using VBA

by Ilker | Oct 9, 2018 | Excel Macros, Excel Tips & Tricks

Finding cells with errors can be tricky, especially in large workbooks. In this article we’re going to show you how to display cell formulas in Excel that contain errors using VBA. How to display cell formulas in Excel that have errors VBA has predefined types...
How to lock a cell in Excel formula using VBA

How to lock a cell in Excel formula using VBA

by Ilker | Oct 3, 2018 | Excel Macros, Excel Tips & Tricks

Users entering data into the wrong cells or changing existing formulas can make data collection a tedious process. However, you can prevent users from going outside the intended boundaries by disabling certain sections of your workbook. In this article, we’re...
How to un-protect a protected worksheet and vice versa - the VBA method

How to un-protect a protected worksheet and vice versa - the VBA method

by Ilker | Oct 3, 2018 | Excel Macros, Excel Tips & Tricks

The common ways of locking or hiding tabs in a workbook can be easy to reverse for many users. Using VBA code to do this is considered a better way to do this, if you are familiar with macros. In this article, we’re going to show you how to...
Page 7 of 8« First«...45678»

Recent Posts

  • Bridging the Gap between Spreadsheets and Web Applications
  • No-Code Solutions in Different Industries
  • How to Improve the Quality of SpreadsheetWeb Hub Applications Created with Automated App Generation Feature
  • Unlocking the Power of SpreadsheetWeb: Essential Tips and Tricks
  • Column Format Feature: Mastering Data Organization with SpreadsheetWeb Hub 

Product

  • Features
  • Demos
  • Customers
  • Developers & API

Solutions

  • Marketing
  • Human Resources
  • Finance
  • Sales

Use Cases

  • Online Calculators
  • Sales Quoting
  • Timesheet Apps
  • Scored Questionnaires

Support

  • User Guide
  • FAQ
  • Training Videos
  • Case Studies
  • Tips

Resources

  • Blog
  • Excel Applications
  • Excel Tips & Tricks
  • Excel Formulas
  • Excel Macros
  • Excel Templates

About

  • About Us
  • Contact Us
  • Services
  • Facebook
  • Twitter

© Pagos, Inc. - All rights reserved - Privacy Policy - Terms of Use