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