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

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