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

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