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: Total
  2. Macro to choose Specific Workbook from a directory
  3. Solved: Combination list using VBA
  4. Array Of Variables
  5. [SOLVED:] Improve my code?
  6. Checking & Deleting
  7. calculating the joint variance of two distinct cell ranges
  8. Need help for "if" in excel
  9. Solved: Macro to change file format.
  10. Extracting Unique Highest Values
  11. Solved: activesheet.type always 3?
  12. Searching and copying
  13. Inserting a New Row
  14. Solved: Excel photo handler : Malcolm Question
  15. Solved: Double click to delete as shift column
  16. hiding a property of a cell
  17. Date Problems on VBA Forms
  18. deleting rows based on content of rows below
  19. Grouping
  20. Excel 2003 / 2007 Compatibility Problem?
  21. Trim in VBA
  22. Solved: Get last cell in Worksheet
  23. Delete Rows in which a given cell contains a text string
  24. Confusion about Union method
  25. blank cell values
  26. Solved: Pushing Excel data to a Word template
  27. Using VBA to Add A Reference
  28. Nested If
  29. Excel VBA Coding
  30. Solved: Usernname in a cell
  31. Excel VBA Coding (extracting information from a list box)
  32. Solved: Find the last row in a range
  33. Need help with assignment -Datafiltration
  34. Find group of records that match index and then do xxx
  35. Solved: Date Format
  36. Solved: Autofill to just above next cell with value?
  37. automating register
  38. Solved: Fix the Controls
  39. Remote File Updates
  40. Solved: Code breaks in iteration of loop.
  41. Stop & Resume Timer Control in Excel VBA
  42. Solved: Find the first Row
  43. Redim Multidimensional Array and perform worksheet-based calculations
  44. Solved: User Input - Amend A List
  45. Solved: Run a macro with the opening of a file
  46. Copy Data From Closed Workbook Without Opening
  47. Solved: Individual Cell Selection and Format Changes
  48. Solved: Show/Hide Columns and rows depending on cell value
  49. Solved: Formatting a number in TextBox
  50. Solved: E-mailing from excel
  51. Solved: hide columns in other sheet based on dates match
  52. How to integrate an undo command into conditional formatting VBA code
  53. How to check if a file is open using Excel VBA?
  54. Range Select
  55. Closing Word Application from Excel
  56. Solved: enter value in cell based on another cell
  57. Solved: automate =sum for two lines
  58. Macro to un-filter data
  59. open protected excel
  60. MI Data via User Form
  61. Excel ranges don't save as strings
  62. questions of copy
  63. I would like to encrypt some data. How?
  64. Solved: Problem with separator in functions...
  65. [SOLVED:] Enter date in Column A based on another row
  66. Solved: Range help
  67. [SOLVED:] Adding two cells together
  68. Solved: Copy/Paste rows on two sheets simultaneously..
  69. Solved: Visual Basic Programming
  70. Solved: deleting rows beneath active cell one by one till value is found in column
  71. Solved: compile error with simple macro
  72. Solved: Macro help: Loops
  73. Macro to Copy only 10 rows per worksheet
  74. Auto printing command
  75. How to shorten this down?
  76. Data validation
  77. Solved: Using a function in another function
  78. Conditional format help
  79. Solved: Code to insert a row at the end of the current sheet
  80. Solved: create a list from other files
  81. Solved: Select Grand Total in Pivot Table
  82. Solved: copy and paste locks cells on a protected sheet
  83. Inventory Management
  84. Macro for Word and Excel
  85. Find Multiple Cell Values
  86. Transpose specific row data to columns
  87. Refedit issue
  88. Scatter Plot chart
  89. Solved: Reading one cell value into an array
  90. Changing reference between sheet cells in different excel file
  91. Solved: ENCRYPTS
  92. [SOLVED:] Iterate through array with date criteria
  93. Solved: import csv from the web
  94. Solved: Replace lookup formula
  95. Solved: Display folders in excel
  96. Solved: Comple error
  97. Solved: Pivot table or SUMPRODUCT
  98. Solved: Ambigous Name Error
  99. Run Time Error: 1004
  100. Solved: List help
  101. Excel Date
  102. Excel spreadsheet help
  103. Solved: Data Summary
  104. Solved: SUMPRODUCT across 4 columns
  105. Solved: Size of Array
  106. SOLVED: Create multiple named ranges on sheet based on cell values
  107. Solved: Help with Dynamic formula
  108. Selecting Non contiguous Range
  109. Solved: "Auto" update
  110. Solved: Passing Procedure or Function name as variable
  111. Help using activeX controls in VBA code
  112. Solved: Match 3 cells?
  113. HELP!
  114. Copy/Paste Data turns black
  115. Solved: Date + 1 year
  116. Solved: Sum of unique value using sumproduct
  117. Solved: Using Programmed Array in Worksheet Function
  118. Move rows if conditions meet
  119. Chart Range References
  120. Solved: Dates in Filter macro
  121. Change Pictures
  122. Solved: check Ctrl + Shift + Enter array size
  123. how to validate cell input for 10 digits only?
  124. Create Chart using VBA function
  125. VBA: return an item from an array (without using a loop)
  126. Insert row with criteria
  127. Solved: Renaming / Reorganizing files / directories
  128. Revisit Last Accessed Cell
  129. About excel vba objects
  130. Data referencing problem
  131. Solved: Last Row in Range (again)
  132. Run-time error and invalid reference (related)
  133. Solved: macro to save file in my documents
  134. Solved: Consolodate data on one sheet
  135. VBA -how to get every second row?
  136. Procedure stops running after UserForm.Show
  137. Check for the Date
  138. Capture names from 2 arrays and create three new arrays
  139. Open work sheet
  140. Amend vba to add file name on save as
  141. Grab worksheet From Closed Workbook
  142. Assigning label caption to a variable
  143. Sum cell values on several worksheets
  144. Solved: Cut Header from a set of data and paste the same next to the Data in C& D Col
  145. Solved: Blank Null Space
  146. Solved: simple activation key macro
  147. Solved: Multiple tasks for one command button
  148. sum with conditions
  149. For Each Next Loop problems
  150. Solved: Pivot Table VBA problem - simple ?
  151. Not sure if you can help me... Noobie here
  152. Interesting Excel Question
  153. Help with countif, 2 crteria required
  154. Arrays
  155. Solved: strange problem-macro fails every ALTERNATE time!!
  156. A simple database project
  157. Solved: workbook protection allowing admin / user access
  158. VBAProject
  159. Fun Excel - Spiral through a range
  160. How to insert required rows instead of a single row
  161. Multiple rows slection for operation with rows
  162. Clear all except first row
  163. Email help request.
  164. Solved: SORT of need help
  165. Showing Progress in a Label
  166. Solved: Creating multiple charts in single worksheet vith VBA
  167. How to Cycle through 5 different Pay Scale Possibilities?
  168. select all sheets
  169. Macro to check and send data to Array.
  170. Chart use array as sourcedata
  171. 3rd party VBA editor
  172. Solved: Force users to enable macros
  173. Code needed for popup message box asking for password to open & use workbook
  174. Solved: Automating histograms
  175. Problem with "Fill combobox with ordered list"
  176. [SOLVED:] User Form - Restrict Entry
  177. Solved: Print Reports Based on Cell Value
  178. [SOLVED:] Run this with a condition
  179. Solved: Useless Data Because of Abbreviations?
  180. Solved: Checkbox not allowing me to check
  181. A40 last cell
  182. Macro running extremely slow
  183. Solved: Find a defined name with VBA
  184. Solved: Reverse code result
  185. Calculus graphing
  186. List Last nonblank cell in comment box or popup
  187. Solved: Advanced help needed :S
  188. export date from text box to the right sheet
  189. Lookup data in Oracle database
  190. EXCEL HELP
  191. help Excel code
  192. How do i match up two columns of data?
  193. Buttons thats copy the Caption in a cell
  194. Syntax Help
  195. ADO recordset search
  196. Solved: macro to copy and paste only 5 rows of the filtered data from sheet2 to sheet1
  197. Dierctly copying a cell that might be merged
  198. Code doesnt work as add-in
  199. General Build Questions
  200. Solved: trouble getting a progress bar working
  201. extract row number
  202. Excel Shrink
  203. VBA Save As
  204. Solved: Many comboboxes with one name
  205. Update cell data based on Listbox selection
  206. How to save screen as gif file
  207. MULTIPLY LISTBOX QUESTION - RANGE
  208. Deleting Rows
  209. ComboBox retrieval.
  210. Project of the Week
  211. Solved: JOB: copying data from one sheet to others
  212. Solved: Send mail to 100 mail address
  213. export txt file data into excel and filter out req'd data
  214. copying cells
  215. Syntax Help
  216. Orthoganally adjacent placement.
  217. Solved: Create a list dependant on dropdown
  218. Solved: Edit KB Encrypt Code
  219. Interesting project?
  220. Code needed: Find or Vlookup
  221. Solved: Check for Vowel or Consonant
  222. Solved: How to kill that finger (macro pointer)
  223. Solved: SpecialCells bug
  224. Find and replace multiple items
  225. Need help with correct finding/sorting. Explanation and example file enlcosed.
  226. Named Range Operations
  227. Need Creative Input
  228. Converting Text to Dates... Fast!
  229. Solved: How to insert "Are you sure? -> Yes/No" in code
  230. Seating problem
  231. xllastrow range - problem
  232. Create control associated with row
  233. Solved: Form & Filter
  234. differenec between two cells - tricky one
  235. Print a document double sided
  236. Excel VBA Export Import Module
  237. Solved: Display result to 3DP?
  238. Resize Range Method
  239. VBA Simulating a mouse double click
  240. [SOLVED:] Versions 97, 2000, & 2003 vbGeneralDate
  241. Solved: macro to open all hyperlink files and save as different sheets in the workbook
  242. VBA to extract data from 2 excels
  243. [SOLVED:] Return true or false if defined name is there?
  244. Solved: Setting a benchmark line in an excel bar graph
  245. Solved: Sending an email from excel
  246. Find and subtract
  247. Time Capture To Log Files using VBA
  248. Excel Formula
  249. Excel Formatting in VBA
  250. Solved: MS Query and Excel