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

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