PDA

View Full Version : Excel Help



Pages : 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 [30] 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174

  1. Solved: highlight same model
  2. how to close an excel file from command line?
  3. Scroll Bar/Control Toolbox/Forms
  4. making calculation easier through data organization
  5. Solved: Manipulating Activesheet Shapes?
  6. Solved: Renaming Worksheet during Copy fails
  7. Delete row based on Data in two Columns
  8. Inputbox format
  9. How to exit loop
  10. Solved: function help
  11. Solved: add data in one cell based on condition
  12. misbehaving DirectPrecedents
  13. [SOLVED:] Loop problem
  14. Auto Save
  15. Need data from another ss
  16. Multiple User sheet protection and access
  17. [SOLVED:] dynamic reminder
  18. Solved: Solver querstion
  19. Challenging project - Date
  20. Solved: Open a Web Page on Validation
  21. help: Nested function as simple as UDF, but faster in calculation speed
  22. Solved: Create duplicate workbooks based on list
  23. input same value in multiple cells
  24. Solved: Multiple Tab Data to Chart
  25. xlVeryHidden in WorkBook_Open
  26. Disable link prompt from showing
  27. Keyboard
  28. Copying active worksheet to new workbook with module to go
  29. Solved: powerpoint paste
  30. Date Update
  31. Solved: "save as" subroutine and checking for saved status
  32. Solved: Find all instances of and then count
  33. Open minimized & save report (Newbie!)
  34. [SOLVED:] Pull data from web
  35. turn formula to value
  36. Export data to new WB and Add sheets
  37. Connection String in Excel VBA
  38. Keystrokes from Office Macro into third party App (SolidEdge 2D free)
  39. Solved: How to keep number value displaying fractional value
  40. Change Focus to non-office window.
  41. Solved: Copy Range and paste it into a insert comment
  42. Looping Through an Array
  43. Relational Lookup
  44. automatically delet pictures
  45. Solved: Duplicates
  46. Solved: hide columns based on value
  47. Solved: Delete row range based on criteria in multiple columns
  48. Excel 2007- Who is Using and Is it worth upgrading?
  49. Solved: Copy entire sheet to a new workbook
  50. Date & time problem
  51. Solved: creating a summary report based on column data
  52. Removing a cell from a selected range
  53. extract text in strings
  54. [SOLVED:] Empty Cell Highlight
  55. Solved: Dos Command in excel: "COPY " & file1 & " " & file2
  56. Add sheets and copy data
  57. how to create file open dialogue box for consolidation
  58. Need help transfering data into another workbook
  59. Sending E-mail from Excel via Comman Button
  60. Test if column has only one value?
  61. Solved: Deleting Columns on Conditions Matched with an Array
  62. Find & Rename Text
  63. Working two worksheets into a third worksheet
  64. Problems with winhttp
  65. Solved: Deleting rows with odd conditions
  66. Solved: Summing Problem
  67. Breaking up a cell
  68. Excel locking up when trying to delete all cell contents or select columns
  69. What IS the purpose of "Design View"?
  70. Capturing a list of files (for email attachments)
  71. Solved: Change Powerpoint Textboxes
  72. Solved: Mapping Excel Links
  73. Set the default file path and Extract the last value in nth occurence
  74. Solved: Compatibility
  75. apply this VBA code to work in two worksheets in one workbook
  76. Need help combining two sets of code into one sheet
  77. Solved: Another Array Question
  78. Use FIND, skipping one
  79. Calculation keeps getting changed
  80. [SOLVED:] Solver in 2007
  81. Read Only to Read/Write and back again
  82. Creating a List Array for use in an ADO query
  83. Setting up an array
  84. Hide Row if cell has specified word
  85. How have spreadsheets changed your work?
  86. Need VBA urgently......
  87. Solved: check for add in progmatically
  88. Compare same number in sheet1 and sheet2
  89. Find the "False" words in the worksheet
  90. Countdown timer in VBA
  91. Solved: Match & Fill
  92. Excel 2007 auto install add in
  93. Solved: Remove Custom Menus
  94. Sleeper: Solver.xla excel 2003 help
  95. Solved: Code fails to run on Non-ActiveSheet
  96. Solved: Pop up box when clicking a cell
  97. Remove duplicates from Multiple columns than tally results
  98. Importing Web Page with Hyperlinks into Excel
  99. How to stop a running macro by user click event?
  100. Help:Left Function Library
  101. REMOVE ROW SUBJECT TO STRING VALUE -please review code
  102. Help to get last cell of selection
  103. Solved: Logic Puzzle hints
  104. Call a form in a other workbook
  105. simple loop
  106. On Error GoTo Again: Erase Array
  107. Solved: Data being reset when cell content is changed
  108. Solved: macro to print cell comments
  109. Solved: Assist. Placing Code in Correct Location
  110. problem with a macro
  111. TALLY MULTIPLE COLUMNS AND OUTPUT TO NEW WORKSHEETS
  112. delete umatched items from two seperate worksheets
  113. Should This Code Work
  114. Problem w/ block of code- Formatting Fractions
  115. Solved: Unprotect with input box
  116. Solved: Protection
  117. [SOLVED:] Last cell selected
  118. vba code.... change column width on selection of pivot table
  119. CheckBox and ListBox Problem
  120. Solved: Byref argument type mismatch
  121. Solved: Find and Replace *
  122. Copy Visible cells code
  123. Update Pivot table
  124. Image Preview
  125. text box
  126. tying cells together for automatic updating
  127. How to limit SQL right and left number
  128. Solved: Get data from sheet
  129. Amend Code -
  130. [SLEEPER:] Extract data problem in the sheet
  131. Save sheet as a separate file based on cell vale of main sheet
  132. Which year in the period
  133. If two cells match from any given row then...
  134. Solved: Sum across worksheets VBA
  135. How to speed up loop
  136. Code to pick a workbook and add a code to it
  137. Solved: flaw in my code - creating a summary report
  138. Solved: merging worksheets based on unique identifier
  139. Names of cells linked to Control Sources
  140. Need help with an Excel VBA ado query
  141. Solved: Default file name in Save As dialog
  142. Macro to advance filter Data
  143. Solved: Onkey to insert symbols
  144. Solved: Trying to have text box in user form display cell contents
  145. If Problem
  146. Use the 2 colors to differentiate the Run File and Undo File in listbox
  147. FollowHyperlink problem
  148. Solved: Distributing data among sheets
  149. Main 2 ListBox problem into my vba program.
  150. Parameter query using excel range
  151. Solved: Userform Restart Sub
  152. use looping to replicate data table functionality
  153. Solved: display results only
  154. Error showing userforms
  155. ComboBox .List problem
  156. Solved: Quick question for anyone with VB
  157. Solved: Subscript out of range
  158. Transfer ListBox1.List to ListBox2.List
  159. Sheet Name Problems
  160. Solved: return value on column selection
  161. Progress Box
  162. Run Once @initial Startup
  163. Convert First Sheet in Workbook to PDF
  164. [SOLVED:] SaveAs Text File Changes Display Value: Stop This
  165. restore comannd bar .control
  166. Using sheet references in VBA on a VLOOKUP
  167. Excel file doubles in size
  168. disable an inputbox
  169. Changed Named Range of Chart
  170. Solved: Early loop exit
  171. Solved: UserForm questions
  172. Progress bar code help
  173. chart object change
  174. Solved: Same Value and SUM
  175. Validation Issue (Excel 2003)
  176. Solved: Workbook Code Module Excel 2007
  177. Kakuro
  178. Solved: Code is clearing clipboard
  179. Copy Range and paste it into a insert comment Part 2
  180. Excel ComboBox - Setting Value
  181. Reopened: Cell contents erased by user form
  182. Solved: Update a cell based on another cell.
  183. Solved: Balance 2 columns
  184. combo box
  185. merge ajacent cells
  186. Reduce size of Excel file
  187. Assign Custom Toolbar Button to XLA Sub?
  188. Solved: delete all sheets not in array(1 to 4)
  189. activate sheet
  190. csv to multi-column listbox
  191. Solved: Suppressing a message box
  192. Solved: Creating and naming a file
  193. Saving selected worksheets in VBA
  194. Error Message, Warning Message: List/Database
  195. Help: Dynamic Timeline Chart
  196. Send worksheets in body of email(outlook)
  197. Disable Virus Scanner Check?
  198. Custom Toolbar Help
  199. [SOLVED:] Add a comma after last name
  200. Solved: Search Excel data from JScrpt web page
  201. Not able to go beyond 9
  202. UDF to Calculate the Month
  203. Excel Sheet "Save As" Text File without altering active document.
  204. Solved: loop not working
  205. Time Tracking
  206. Using Access Queries in Excel
  207. Solved: Dealing with numbers with leading 0's
  208. Solved: detect which version of excel is running
  209. Solved: Bypass "Enable macros" warning
  210. Solved: How To Find "Max Value Of A Collection" ?
  211. copying data extact match vba code
  212. sumif across multiple sheets
  213. Solved: Clear cells in column A if column B has a zero
  214. Paste excel table into Word and then format?
  215. Solved: Moving data from sheet1 to sheet 2
  216. [SOLVED:] Help with Autoformat pls
  217. changing sheet tab colour
  218. Solved: Basic Question: EntireColumn Property statement
  219. Solved: application/object defined error when .IsAddin is true, but not false
  220. Run a Private Sub from a Keyboard Shortcut
  221. Solved: Install Add in and set reference
  222. Short cut keys won't run entire macro
  223. Solved: Quarter Hours?
  224. Formatting table in Word using Excel VBA
  225. Solved: Selecting the one row above with the relative range
  226. Copying Excel charts To Powerpoint via VBA
  227. Solved: How to initialize scroll bar w/o active object
  228. Relative scales
  229. Solved: How do I get the formulas to work on my userform
  230. Help with sorting data
  231. My first userform
  232. Copy and Paste data from multiple cells
  233. Stumped with XL 2007 Add-Ins Tab
  234. Solved: Create pivot table help
  235. Amend code - Important - Please
  236. Open text file and delete lines.
  237. Checking for Optional Argument
  238. Solved: Test if a Column Field Exists in Pivot Table
  239. Solved: The Macro "macroname" Cannot Be Found
  240. Read cell contents from a closed file?
  241. New to VBA - Importing data based on a cell value
  242. Solved: How Can I Disable A Macro from Another WB?
  243. Determine if a file has been updated
  244. Hyperlinked List of Directory Contents
  245. FSO Properties
  246. Userform Question
  247. How do I check for data
  248. Solved: Converting all files in a directory using VBA
  249. Number Comparison
  250. Restoring a worksheet using a Macro