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