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

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