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