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