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

  1. Enabling and Disabling Buttons
  2. Solved: Compare 2 collums and have a message box display varience
  3. add a picture to comment
  4. User-defined type not defined
  5. Solved: MsgBox "Prompt Message"
  6. Windows task scheduler and Excel
  7. Solved: need to select and run macro on all worksheets in workbook consecutively
  8. GOTO A different Worksheet named in cell A1
  9. Solved: how to open a folder?
  10. Solved: Checkbox confirmation
  11. Help: How to get date input in specific syntax
  12. ComboBox help
  13. Hide Rows Based on Condition
  14. Solved: Keep Track of a Workbook Review
  15. Locking Form Controls
  16. Simple Comparison
  17. Solved: Filter list and place results below
  18. Solved: filesearch for .txt and text conversion
  19. Count number of times word occurs in selected column?
  20. Solved: Custom Menu and Toobar Items for a single file.
  21. adding/sizing images.
  22. Solved: RESOLVED - How do you set a max column range?
  23. Solved: Alert Message and highlight duplicate
  24. Solved: Build file string to import an HTML file
  25. Solved: Need to convert date to three letter month
  26. Solved: Split test column as string
  27. Inconsistent Behavior When Capturing Application Events From xla Add-in
  28. Data validation with dependent dropdowns from a sorted list - seperate document?
  29. Solved: How to reset only the current row color?
  30. Create a new worksheet from existing worksheets plus doing calculations.
  31. Solved: Extracted Sheets Limits to 43 only why?
  32. Solved: Formula in vba help
  33. Tracking blood sugar levels
  34. Class property vs public variable
  35. Solved: Range cell color by Double Clicking
  36. Solved: Problem delete and replace item
  37. HTML Data to Excel Cells...Help
  38. Can I Cascade Dependent Validations?
  39. Error running second time
  40. Solved: Split ONE word into TWO cells
  41. Solved: BeforeDoubleClick Question
  42. Solved: How do you prevent a row color change event?
  43. Solved: Timesheet Weekly Totals Help
  44. Solved: Is MS excel installation necessary to run VBA code?
  45. Solved: Insert lines after so many rows
  46. Closing Errors...
  47. Solved: Connect to Oracle
  48. Solved: userform to search datasheet & return values
  49. Solved: If make confusing..
  50. Solved: Printing an array of sheets
  51. Solved: Test if there is a Ranged Name already
  52. Solved: Extracting just the Number in a name
  53. Visual Basic - Import and Insert Photos
  54. Skip Cell VBA Help Change Code
  55. microsoft access barcode control 9.0 active X running error
  56. Solved: If Value in one column is something and another column is mandatory
  57. Renaming Defined Ranges
  58. How to load specific items to the listview 6.0
  59. Solved: OT - Help Needed To Access My Own Workbook
  60. Solved: Can this code be made any more efficient?
  61. Solved: Range Select problem
  62. Can not understand what it means!
  63. Create Copy of a Control
  64. Solved: Help improve reverse loop
  65. MSCOMM32.OCX ....Problem
  66. Solved: How to create a "Live" points table
  67. Solved: Merging sheets and stopping Excel from date formatting cells
  68. execute excel
  69. Solved: Floating Toolbars
  70. Progress Bar
  71. Solved: Finding ID Number & Using That Row
  72. Trigger a macro when result changes
  73. How to protect my project
  74. Solved: Log In-Out Sheet
  75. Worksheet DoubleClick Event
  76. Solved: How do you run ThisWorkbook code from a module?
  77. Solved: Sheet tab change event
  78. Filter ListBox based on a ComboBox
  79. Form not changing transparency
  80. Solved: manual calculation for individual workbooks
  81. Solved: bloating of file
  82. Solved: slow to open a workbook
  83. Solved: Making my code smaller
  84. Solved: Different expressions of a simple formula
  85. Fully declaring each variable
  86. Solved: Is it possible to protect specific cells on the sheets,
  87. Un check a CheckBox when others are checked.
  88. Find shapes in sheet
  89. Solved: Pivot Table Help
  90. VBA userform calendar
  91. Vba code for importing external data
  92. Compare two columns for any one word
  93. Rich Text Format RichTx32.ocx found in \system32 but does not display
  94. Reference question
  95. mismatch error
  96. Logic assistance, please.
  97. screen up by code the option form (security tab)
  98. Still need help with this vba code
  99. comment autosize help
  100. Solved: VBA code to merge Worksheets Of Up To 1 Million Records In Ex. 2007
  101. Renaming sheet name
  102. Sumproduct formula help
  103. Scheduling servicing
  104. Help needed VB code - file name with dates
  105. Solved: Compatibility of Macros coded in 2007
  106. Hlookup returns wrong field
  107. Solved: How to change the index of an array
  108. excel to xml (problem with listed elements)
  109. Chart Object Disable Right Click
  110. Solved: Issues with Find
  111. Solved: Update Formulas to include added rows
  112. trying to add the new name of a file in a cell
  113. Solved: Count Dates in a Week
  114. Multi Criteria Macro
  115. XML in VBA
  116. Real Random number
  117. Fine tuning an If formula. Cells matching based on Condition
  118. Need help with vba code for deleting trailing spaces before or after an entry in a co
  119. Solved: Linking sub's and selecting cells for a sub
  120. Need Help testing if a cells contents match that of a cell in another column
  121. Solved: count dates in a week (continue)
  122. need help
  123. Solved: smilies in excell 2003
  124. Group with sum.
  125. Date Format issues
  126. Solved: Autofill Cells When Another Cell Has Value
  127. Solved: Is there an ISnumeric or Formula code
  128. Date format testing fails
  129. Solved: again problem with counting date in week
  130. Ini. Files problem
  131. Solved: Prevent users from editing every 'nth' row - eg every 3rd or 4th row.
  132. Solved: hi code tweeking
  133. Code for changing an entry to uppercase
  134. Right Click menu changed due to macro - how to modify?
  135. Formula for summing vertically based on horisontal condition
  136. Solved: if (RC[1]) = 1 then "=TEXT(RC[-1],""MMM/YY"")"
  137. Solved: Array Formulas Using CTRL SHIFT ENTER
  138. Solved: Sendkeys using wait.
  139. Solved: test selection for first and last row
  140. Change Col diff into Col letter
  141. Show Date And Time Of Latest Import From Yahoo! Finance
  142. Solved: Close workbook based upon cell value, but don't save workbook
  143. Solved: ANNIVERSARY YEARS
  144. mirror fill color from reference cell
  145. parse text
  146. changing cell contents on basis off another cell
  147. Access Report
  148. Solved: web forms/log ins + VBA?
  149. Copy Duplication
  150. Copy Data From WebPage To Excel
  151. Mail to macro
  152. macro to run a series of tasks
  153. Saving data in .dat format-help needed
  154. Solved: Checkbox issue
  155. UserForm - List Box Error Message
  156. Solved: One sheet dependent on input on another?
  157. Solved: CELLS W/ NO VALUE NOT EQUAL TO BLANK
  158. VBA Web Query Generating Error 1004
  159. Rename file excle
  160. vlookup match columns
  161. Include Row Number in XLFilterCopy
  162. Solved: Userform Calendar Control modification
  163. Solved: formula to extract number
  164. Solved: Lookup & transpose variable range from 1 To 3 columns
  165. Solved: Check cell for text
  166. Have predetermined data appear in one cell, when specific data entered in another.
  167. Solved: Locking down a spreadsheet
  168. Find for a specific word and extract details based on the found value
  169. Save columns A:D to C:\
  170. Copying new data from one sheet to another
  171. repeated action
  172. Solved: Open File on shared network drive and copy information to sheet
  173. Solved: Sum Dynamic row in VBA
  174. Track changes if array or multiple cells are changed
  175. Solved: how to condense results from multiple sheets
  176. Solved: Define range and combine two codes
  177. Solved: Making more checkboxes visible when a checkbox is checked
  178. Solved: Sumif with concatenate and wildcard
  179. Go To Dialog Box Width F5
  180. Solved: help with saving a program
  181. Solved: Accessing Cells With Activecell.offset
  182. Solved: UPDATE FORMULA
  183. Locking cells in different range
  184. Solved: Create new folder within VB
  185. Show messagebox if user selects locked cells
  186. Solved: vLookup like ?
  187. Mail merge where person and file name are the same.
  188. Locking blank cells only via VBA
  189. Import and split large tab deliminated text files
  190. adding a message box icon
  191. Solved: fill in every other row
  192. Excel to Power Point
  193. sending mail from excel via smtp-relay
  194. Value change with date
  195. Validating column Heads
  196. Linking Excel to Access Forms
  197. problem with date format when I use userform
  198. Solved: Specify 63 Days From a Date
  199. Code to Export as xml file
  200. Solved: Double Click a cell to show form with data
  201. Copy Data
  202. Check no selection in a listbox..
  203. Solved: VBA Message Box
  204. Incremental number for saved files
  205. Solved: Vlookuping a separate sheet
  206. Disable cut & paste in active workbook
  207. Solved: Names I define in a macro ignored by workbook?
  208. Solved: copying cell value only when calculated from formula
  209. Fastest method to read data from sheet
  210. Multipe Goal Seek across workbooks
  211. Solved: vlookup from another worksheet
  212. Solved: Compare the values between two columns
  213. dynamic Validation criteria
  214. Set bottom of variable range
  215. Solved: Message box ( Open Event)
  216. VBA Code Error
  217. Solved: Reverse Lookup Last Record Ignoring Location 300
  218. % movement tracker macro
  219. Solved: Create quarterly summary report from details
  220. Make file read/write
  221. Exporting Spreadsheets
  222. Solved: Column search returning wrong results
  223. Solved: formula simplificiation
  224. Frequency filter by date and sorted elements
  225. Solved: Last Row Array help
  226. Vlookup for all the row?
  227. Solved: Newbie once again, importing a module
  228. UserForm Initialize or Activate Conundrum
  229. Solved: Do ... loop
  230. Solved: Concatenate into a Single Cell
  231. Still need help with this vba code
  232. find duplicates entries
  233. Using VB with variables to access data from web sites
  234. GoTo versus Resume within an error-handling routine
  235. runtime error 1004
  236. Append to master list?
  237. Dynamically change number formatting within a column
  238. Help with code cleanup.
  239. Modify Macro to go from Ascending to Descending Order
  240. VBA Sub Procedures; Homework
  241. Advice and Tips for instr & for Findnext
  242. Dir function returns fileNames not as expected
  243. Solved: Help with For....Next, and some useful code for everyone
  244. VBA Help: Homework
  245. Concatenated Message Box: Homework
  246. Select Case Statements; Homework
  247. Solved: Help transfer excel table to access db
  248. VBA Case Statement verification; Homework
  249. Macro to hide blank rows in Workbook
  250. Variable column in code