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