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

  1. Getting around Pivot Table 256 Col Limitation
  2. Connections in MS Excel 2007
  3. Solved: Delete function failing
  4. A complex IF formula
  5. Date Dif function
  6. Solved: Best way to select these ranges w/ macro?
  7. Trim not working and moving through a range
  8. refreshing data in excel
  9. Check or selected rows in array?
  10. Date Stamping a Cell Modification
  11. Treeview Losing Checked Checkboxes
  12. Search certain column in all worksheets and paste rows to seperate worksheet.
  13. Excel macros (if statements etc) how?
  14. Worksheet activate code in Add-in
  15. Rolling Reference number
  16. Solved: What's wrong with this function?
  17. Solved: Userform and data validation
  18. Want a Userform
  19. Transposition and rearrangement of data using VBA
  20. CommandButton &i.Elabled = False
  21. Number format to dispaly on a label from text box
  22. Excel VBA Copy & Paste
  23. CODE CANT BE WORK
  24. Solved: Macro to warning user of duplicate entry
  25. Solved: Automate msgbox cancel
  26. Solved: problem with a conditional average
  27. Solved: incorporating condition or math into sumproduct
  28. Solved: Select item in list if only one exists
  29. Activate range on a different sheet
  30. Copy or link data between sheets
  31. Solved: Find/Replace in One Column over Entire Workbook
  32. Benefit of making sheet object rather than directly manipulating sheet
  33. Solved: Treeview nodes
  34. Solved: 2 formulas required - Part 1
  35. Solved: 2 formulas required - Part 2
  36. monte carlo output: statistics in Excel (How?)
  37. conditional formula
  38. Solved: change formula
  39. txtboxes and cells. Updating editing userform
  40. understanding arrays
  41. Solved: List File Names
  42. Solved: subtract two formula
  43. Using another source
  44. formatting vba to work on a protected sheet.
  45. selecting last row / cell
  46. Solved: Help speed up this code (2 FOR loops seem to be the problem)
  47. Solved: Finding Information in one spreadsheet to populate another spreadsheet
  48. test if Excel 2007 is in Compatibility Mode
  49. Form TxtBox
  50. Loop to extract data
  51. 1024 character limit help
  52. Solved: Need help creating macro to insert col
  53. Solved: [Excel] Open files listed in varialble, extract data
  54. Solved: Format trend line dialog box
  55. Solved: VBA for sorting column with formulas
  56. UserForm control for a background process
  57. Solved: linking text data between sheets
  58. Assistance with formula arrangement
  59. User Form Help
  60. Solved: Assigning a date variable for use in a file extension
  61. Solved: Create Multiple Text Files From Cells & Save As Name In Adjacent Cell
  62. Breaking numbers and letters
  63. Passing Objects: ByRef / ByVal
  64. code help (newbie)
  65. Solved: Transpose Horiz Values to Vertical
  66. Solved: Make textbox visable or not visable on Userform
  67. Solved: Problem with my delete loop
  68. Stop / Pause a Macro using Pause button
  69. problem with preventing "" spreading all over the Spreadsheet
  70. Solved: sheet history before save
  71. Solved: Help with calling out another sub within a sub
  72. Solved: Toggling Display gridlines:
  73. copy range from different sheets
  74. Solved: looping backwards using steps
  75. What routine to use?
  76. multiple e-mail addresses in SendTo,Notes client
  77. copy and paste active cell down a column
  78. For Each loop: exits too early
  79. Task Scheduler via COM
  80. Solved: Allowing macro beetwen 4 - 5 PM
  81. Solved: CustomList Index
  82. Listbox Additem + ListFillRange
  83. excel data manipulation and sorting
  84. Copy Extenal workbook help
  85. Solved: Problem with Typename for Multipage/Page in recursive function
  86. View Excel Charts from Forms
  87. Need Help with the Easist Question Ever
  88. Maybe a Null question?
  89. Worksheet Cell Calculation Order
  90. Runtime Error 1004 - ODBC ERROR - BackgroundQuery
  91. Page Header: Loop based on values in a range
  92. Solved: Excel - Opening files in string or in cell
  93. Creating a "refresh data" macro
  94. Import Txt and Parse
  95. Sorting a Range with VBA
  96. Function returns empty array
  97. progress bar is frozen
  98. Solved: add data based upon created categories
  99. [SOLVED] Application.match failing
  100. storing value, making registration tool
  101. vb and command button help
  102. Solved: Show current users on userform
  103. Writing Excel cells with VBA variables
  104. Solved: Generate numbers 1 - 90 for bingo
  105. Solved: userform and function call
  106. Solved: help optimizing case select
  107. Access Filter Criteria from Excel
  108. TextBox Help
  109. lookup and conditional formatting with VBA
  110. Using Formula To Find Last Used Column?
  111. Prevent 1004 Error For Select Method
  112. change part of a string
  113. Linked Picture to be centred on Screen
  114. question about forcemacros
  115. Solved: How to check the type of an array
  116. Solved: save and rename workbook everyday at a given time
  117. Using VBA for conditional Formatting
  118. Move over Picture
  119. Listbox Limit!!
  120. EXCEL USING IF THEN STATEMENT
  121. Ref Edit Control Missing
  122. Downloading many html web pages, converting to text, then parsing out
  123. Creating a User controlled pause in VBA
  124. Solved: modifying existing chart Sourch data
  125. Solved: Camera tool use with picture object
  126. looping code with if's
  127. Complie if error
  128. Solved: "Pick and choose" series to display on embedded chart
  129. Split Cells help
  130. saving a backup file
  131. arranging data redux
  132. Solved: Importing multiple space delimited text file
  133. Copy and paste withi selected range
  134. Excel in neverending loop
  135. combo box help
  136. Amend VBA Code
  137. Solved: Copy from one xls to other avoiding highlighted cells
  138. For Each.. loop decisions
  139. Manipulating Arrays Using VBA
  140. Seperating records with a blank line
  141. Solved: Help with Experimental Grade Sheet
  142. Quicker way to write a bunch of formulas??
  143. Which control does this?
  144. Difficult: Sum of days in consecutive months based on multiple criteria
  145. Function returning Arrays
  146. Solved: Formula help
  147. Solved: data going to wrong cell
  148. Solved: Spell Check Unlocked Cells on Protected Sheet
  149. Generate random numbers based on odds
  150. Solved: Populate list box from selection in another.
  151. Navigation menu to only show visible tabs
  152. Command button to Hide/Unhide tabs
  153. Solved: Re: Shared Workbooks
  154. Solved: How to re-apply named ranges
  155. Solved: Adding rows with preconditioned cells
  156. Solved: Changing TreeView Node Detail with Userform TextBox
  157. Form, listbox and multilines problem
  158. Solved: NETWORKDAYS formula amendment
  159. Solved: Find unique values
  160. Solved: Renaming folder files
  161. Extract data from columns [sum]
  162. Looping through Range Vs Ranges
  163. Tracking Changes / Sharing a workbook
  164. Solved: Userform Quick Q
  165. How to create a message box depending on values of the cell? Toughie =/
  166. Solved: Label blinking in the UserForm
  167. Solved: If value not found go to next cell
  168. Getting a range to work in my vba code
  169. Trim cells in variable range
  170. Copy, Find and add offset cell values
  171. Solved: Create New Sheet Based on Value In Column
  172. Userform will not Show after being Hidden
  173. Solved: Accounting format
  174. Solved: Automatically change font size
  175. Paste Copy special Value
  176. CSV Import Issues
  177. FileCopy to Network Drive
  178. Solved: Word bookmark Help
  179. Caopying and Pasting While Retaining the Original Cell Reference
  180. [SOLVED] Quick question about loops
  181. [SOLVED] Creating Pareto Chart
  182. Code using date not saving the result of output
  183. User Def Function to only act on active workbook
  184. Solved: problem with resize and autofill
  185. Solved: Opening unknown File names in known Folder
  186. Help with Macro code
  187. Solved: macro to list unique data in a column
  188. Conditional formatting in vba (more than three) select values from a worksheet
  189. Code Wants help
  190. Horrible Listview problem...
  191. How to draw a vertical and horizontal line on a line-plot
  192. Solved: Delete Row but store a value first!!
  193. Solved: CountIF to find Average using VBA
  194. Solved: Moving from 2003 to 2007
  195. Solved: Ideas to make this code faster
  196. Solved: Select All Pictures, And Move And Size with cells
  197. Send cell contents in email message body
  198. Macro to open workbook from another workbook
  199. Solved: Help on changing the year
  200. Help with code for data entry
  201. Solved: Multiline Textbox to Populate Multiple Cells
  202. Solved: Set variable to a cell address
  203. Excel - 2003 VBA Code Error - Run time error '380':Invalid Property
  204. Solved: Select range by used rows and named range
  205. add function on print
  206. Creating Add-ins
  207. Optimizing loop for find&delete shift column
  208. Solved: Macro:To Many End With's
  209. what does ^ mean in the formula
  210. Solved: Copy information to an Activecell that Moves
  211. Solved: Find and select a cell based on user input
  212. Call Excel Solver from VBA
  213. Passing listbox values to cells
  214. Solved: macro to hide/unhide select cells
  215. VBA Page Breaks in Excel
  216. Solved: create chart in seperated worksheet
  217. Image rendering in forms
  218. Match 2 columns
  219. adding code in runtime
  220. Solved: Creating Folders or Directories
  221. Solved: Headers & Footers - Multiple Sheets
  222. Function does not output on Cells
  223. Help Needed with Page Breaks
  224. Disable macros on opening via Hyperlink
  225. flips left-to-right sequence of selected columns
  226. Random Combination
  227. Copy multiple individual cells
  228. Solved: Conditional Formatting for Numbers Only
  229. getting string to resolve to variable
  230. adding access levels
  231. Solved: Print sheet in a loop procedure
  232. ActiveCell.Text
  233. Solved: Regex Query
  234. Fill data validation cell
  235. Getting a line in a graph to change colors
  236. Solved: Automatically Add Zeros in a cell
  237. Search, copy, and paste
  238. Javascript:_doPostback
  239. Solved: Merge cells into one if value is smaller than...
  240. Solved: [RESOLVED] Import a text file and keep the spaces
  241. Macro that automatically imports excel data into access database?
  242. Solved: Function in add-in - How to reference workbook?
  243. Problem with Range and Worksheets
  244. Solved: Split listbox text
  245. Solved: Excel macro to loop through rows, while looping format rows if meet criteria
  246. Solved: Numeric calculus for Matrices
  247. converting .ps to .pdf
  248. chart base on category
  249. Copying from cells on same row selected by user
  250. Solved: beginning with userforms