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