You are here:

  • Home
  • Computing/Technology

Computing/Technology

Recent Answers

2014-10-20 Excel - VBA to make new columns:

Tae,    Here is the code which I tested with your data and it appeared to work.     In the Array(...) put in the 10 categories.  Make sure there are no misspellings from what is in column J in your data

2014-10-20 Pagemaker (Adobe) - adding or editing text in Pagemaker 7.0:

Works on laptop.....    I have PM 7 on Win7 and have not had that issue.   If you open a new document, can you place a graphic in it (desktop version)? Can you draw circles or rectangles?    Could you

2014-10-20 Excel - VBA to make new columns:

Tae,    If you just want logic, then I would first sort the data.  Then you only have to loop through the data once.  I would write the category names in additional columns on the right.      Then I would

2014-10-19 Excel - Altering VBA:

Christopher Mitchell,    Here is a demo from the immediate window:    Set r = Range("S1,S5:S15,S20,S300:S301,S10000")  ? r.address  $S$1,$S$5:$S$15,$S$20,$S$300:$S$301,$S$10000  ? r.EntireRow.Address

2014-10-19 Excel - Altering VBA:

Christopher Mitchell,    one way would be to set calculation to manual at the top of the macro and set it back to automatic at the bottom of the macro.  This assumes that excel is doing a calculation on

Categories

Browse Alphabetically

©2014 About.com. All rights reserved.