You are here:

  • Home
  • Computing/Technology

Computing/Technology

Recent Answers

2016-04-27 Excel - Delete rows on large file:

Dear Natalie,    I did a test run of your code and you are effectively deleting all the rows. If that is the case, why would you want to delete them 99 rows at a time, why not delete all of them at one

2016-04-27 AutoCAD - AutoCAD 2015 Open Preview Pane:

Perhaps the problem is in Windows, and not AutoCAD:    Try this:  In Windows explorer, click Organize > Folder and Search Options > View Tab    Uncheck Always show icons, never thumbnails.  (if it is unchecked

2016-04-27 Excel - VBA Question Regarding Checkboxes:

Right-click the sheet tab, select View Code, enter this:    Private Sub Worksheet_Change(ByVal Target As Range)      If Target.Value <> "" And Target.Column = 1 Then          ActiveSheet.CheckBoxes.Add(57

2016-04-26 AutoCAD - AutoCAD 2015 Open Preview Pane:

Hi Bob,    I would start by looking at the variable THUMBSAVE; make sure it is set to 1 (on).      If your issue persists, I would look at the registry value of:  HKEY_CURRENT_USER\Software\Autodesk\AutoCAD\Rxx

2016-04-25 Excel - Searching and deleting rows:

Natalie,    Yes, there is a typo in the code:    Sub abc()  Dim rw As Long  rw = Cells(Rows.Count, "A").End(xlUp).Row   ' added .row  Do  rw = Cells(rw, "A").End(xlUp).Row          ' added .row     If

Categories

Browse Alphabetically

©2016 About.com. All rights reserved.