Top "Vba" questions

I have Range object called DistinationRange which contains reference to range B3:H63 I want to apply the following two …

I want to check if a range in Excel is empty. How do I write in VBA code: If Range("…

Is there a way to take HTML and import it to excel so that it is formatted as rich text (…

I need to get the names of all the Excel files in a folder and then make changes to each …

I have a long list of names that I need to have quotes around (it can be double or single …

I want to click a button on my access form that opens a folder in Windows Explorer. Is there any …

I am copying an VBA code snippet from MSDN that shows me how to grab results from a SQL query …

If you want to clear the contents of a cell or range in Microsoft Excel, you can use .ClearContents. If …

I need to use the value of checkboxes for an IF-THEN statement. Based on what the user checks, the way …

Pardon me as am a newbie in VBA. Sometimes I use Dim r as Range r = Range("A1") Other times …