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: Splitting cell content
  2. Delete VB code
  3. Setting Print area to used range, VBA?
  4. cut and paste a range to a new worksheet
  5. Solved: Range Concatenation
  6. [SOLVED:] Add data from many files (they are in same format)
  7. automatic update from external source
  8. Solved: Create a email send list
  9. Deleting a Chart in VBA
  10. Where's the code error?
  11. Chart Question
  12. trying to lookup a number in a column and edit data in another
  13. Importing a worksheet
  14. Solved: Run a dialog using Macro
  15. Solved: Function help
  16. Solved: Variables declared correctly? Space Continuation?
  17. Advice Needed w/statistics
  18. Solved: need help with #value! error
  19. Solved: Locating a Knowledgebase Workbook
  20. Vlookup reverse
  21. IF statment with cell formating
  22. Solved: Install Office 2007
  23. [SOLVED:] Why is Next used/necessary
  24. Centering answer in Msgbox?
  25. Qualifying Object Reference Help
  26. select and delete a certain date
  27. Array Formula
  28. conditional formating if Teddy I
  29. Solved: create workbook, delete workbook
  30. Selecting a Random Statement
  31. macro to open userform and close everything else
  32. duplicate warning code for 3 columns
  33. Solved: Delete entire row that are duplicates.
  34. insert value into A1
  35. Built-in Help is not working
  36. Solved: Transfer range from excel to access
  37. Solved: If condition false reply by e-mail with variable hyperlink
  38. Assist in developing new procedure: Lists.
  39. Refresh All XMLMaps
  40. Fill Down Automatically?
  41. Sheet Names of XLS within a drop down list
  42. Solved: Checkmark in Active Cell
  43. Solved: Return cell address of VLOOKUP
  44. [SOLVED:] Condense this code ?
  45. Solved: Adding New Sheet w/ Sequential Date
  46. Set field lengths
  47. Populating listbox in User Forms
  48. Copy data from CloseWorkbook to OpenWorkbook
  49. Solved: Limit the Number of Sheets in A Workbook
  50. start header and footers on 2nd sheet
  51. when to use error code?
  52. My macros connects to Oracle and writes to file but no Excel
  53. Solved: Copy RightHeader onto sheet
  54. Solved: Weird Problem
  55. Expand column range in code
  56. Copy only visible cells
  57. Fun with FUNCTIONS!!!
  58. Solved: What are the differences between two?
  59. I need to parse out data into separate columns
  60. Solved: Getting Data from Password Protected Workbook
  61. VBA uploading spreadsheets
  62. Huffman Coding
  63. EVal function in Excel VBA
  64. Solved: Unable to add another record thru click event
  65. Mid Formula - extract numerals..
  66. Hiding Unused Worksheets
  67. How to Internet Explorer's HomePage textbox is enable via VBA?
  68. Solved: BeforeDoubleClick setting column and row?
  69. Solved: Object Required error when inserting data from Excel to Access
  70. automatic sorting
  71. macro for recording changings
  72. PrintScreen Request
  73. Solved: images
  74. Solved: Find Last Row With Border
  75. help on creating new sheets
  76. using loops to search through a text file
  77. Solved: I want to add hundreds of TXT files into one XLS file
  78. Solved: Mega help required to remove 1000 block of code
  79. Solved: select plot area sheet using cell reference
  80. Solved: Counting based on Cell Values
  81. Solved: BorderAround only displays on 1 quadrant
  82. relative-absolute
  83. simple (i think) text manipulation
  84. Solved: Compute Months And Days From Decimal Value...
  85. Calculate how many items are in the data field
  86. Find Last Row for "x"
  87. Break down a string
  88. Email On Click Cell
  89. Sorting inside single cell
  90. Solved: Create hyperlink and activate it
  91. help on duplication code
  92. A useful Risk Liklihood Matrix
  93. Username and Password
  94. create .xls file from false condition
  95. to modify an existing code
  96. Copy worksheets to new workbooks
  97. Solved: Unhide and hide desired sheets from macro
  98. Find Blank Row and Sum Cells Above it??
  99. Insert Row based on partial cell value
  100. how to modify Novell Groupwise VBA script?
  101. Worksheet Change Event
  102. Concept only required
  103. Solved: Forms 101... showing range of cells on a user form
  104. Importing html's source code into Excel !
  105. Solved: How come this works on 2007 but not on 2003
  106. Global Variable accross multiple procedures
  107. PivotTable question
  108. random problem
  109. Solved: Find text, return near by text based on an offset(more efficient way?)
  110. Sorting in PivotTable or Hiding a PivotField
  111. How to solve the strings and sentence
  112. Solved: Setting Available References
  113. Copying to list
  114. Menu bar on a User Form
  115. VBA DateDiff() Problem
  116. Solved: Application-defined or object-defined error
  117. Making a report based on 4 sheets
  118. Options of Excel 2007
  119. Date Format - Non-English
  120. Solved: Statusbar progress percentage value
  121. Solved: Listbox starting value - vlookup disappears?
  122. Solved: Unhide only certain sheets Macro
  123. Newbie Function Compile Error
  124. Save small icons as pictures
  125. Solved: Convert to txt
  126. UserForm-ListBox
  127. Solved: Format Extracted Data
  128. Comparing columns
  129. ActiveCell - shifting from one workbook to another
  130. looping cut & paste
  131. Excel not properly closing
  132. Automatically run macro every 5 minutes
  133. Saving after autodeleting
  134. Solved: How to check the values stored in excel sheet thru VBA
  135. Countdown Clock
  136. Solved: copy data from one worksheet to another in same workbook
  137. Solved: Copying UserForm between project files
  138. Solved: Sheet Change Event
  139. stop closing a worksheet unless press a button
  140. Solved: Why won't this work?
  141. check if a file exists
  142. create and run a worksheet template macro in a middle of other process !!!
  143. Sleeper: Moving Items in a ListBox
  144. Solved: CheckBox Delete in Macro
  145. Need help with a function called PAYBACK
  146. Change Print to 'Landscape'
  147. My Print Layout Reverts Right Before Printing
  148. Solved: Open & copy from files with differing names
  149. Solved: Compare Worksheets
  150. Solved: generate reports.. need help...
  151. Datepicker Null value.
  152. userform help wanted
  153. UserForm, Copy Data
  154. data store in access ..
  155. I lose page break formatting when attempting to print
  156. Deleting Checkboxes
  157. Transfer Array to worksheet
  158. Hyperlinks within a userform
  159. Solved: Speedy PageSetup
  160. Solved: countif and offset help for 2 work sheets
  161. Retrieving data based on a combobox selection
  162. Solved: Range in VBA
  163. 2-Part Workbook Question- Save & Save As
  164. Summing non contiguous range minus last 2 cells of range?
  165. Solved: Curing #NUM! when formula finds no match?
  166. amending Array MATCH formula to cope with blanks?
  167. Solved: Setting the Directory - SaveAs
  168. copy data in the last row automatically
  169. Listbox worksheet help
  170. Solved: create User Friendly Spreadsheet
  171. Highlight if less then subtotal
  172. Solved: Checkbox help
  173. Solved: Help required for Excel VBA query
  174. Solved: Delete Rows with same information
  175. printing issue
  176. Copying and Storing VBA Code in DB
  177. Solved: Delete rows based on Criteria in two cols
  178. UserForm- Select records from Access
  179. Can I combine these into 4 lines?
  180. Using user-defined functions in formulas
  181. reminder box
  182. Clear cell edit
  183. Help With Sorting
  184. function category
  185. SubFolders of GetFolder(x).SubFolders
  186. Help w/ Loop
  187. Solved: Question re: Browse For Folder KBase article
  188. Copying Cell to another Worksheet
  189. Solved: Create Email with Hyperlink to Network Folder
  190. Solved: Concatenate and Autonumbering
  191. Solved: Getting rid of message box
  192. Solved: Chart from a list of cells with count of numbers as data
  193. Dropping off all characters after .xx decimal place (not rounding up or down)
  194. help in unhiding all hidden cells and worksheets
  195. Macro to attach numerous pdf files and email via lotus notes
  196. picking up file names in one folder
  197. Hyperlink to another form.
  198. Solved: Error on "Save As"
  199. Solved: Excel Auto Fill columns
  200. Relative Reference
  201. Solved: Copy cells from a excel form to different worksheets
  202. Command in execution time
  203. Need help, don't know VBA.
  204. [SOLVED:] A Problem in an User Definied Function About Color Info
  205. Solved: Add a Clear Button
  206. Copy Particular Text to Excel File...
  207. Run Macro
  208. Solved: Compare values in same sheet
  209. Solved: How to save OLE object added in a sheet.
  210. Copy data with empty value
  211. UserForm - clear contents for next entry
  212. Sleeper: Few Quick Questions
  213. Solved: Use VBA to compare two columns in Excel and highlight the cells that are similar
  214. Re-setting Checkbox Number
  215. Do Calculation with Form before I enter on worksheet
  216. Solved: "Action" menu item?
  217. Solved: Locating Address without Selecting cell
  218. Attach button to sheet/ access from Private Sub
  219. Find Excel workbooks in many SubFolders and create hyperlink for it
  220. Solved: UDF For Convering a Formula To Resource Addresses
  221. Solved: Variable Help
  222. CVar'ing a string
  223. Solved: Test Date if it is Weekend or Holiday
  224. intersect function
  225. Filtering A Worksheet
  226. Solved: I am getting " ' " in front of text
  227. copying worksheets
  228. Ignoring item in unique list formula?
  229. Solved: generate ws from template adding data from range on main sheet
  230. Compare two xls files and generate a report/result file
  231. copying data from different workbooks.
  232. UserForm clear controls
  233. A Simple Email from Excel
  234. Solved: Run-time error '1004': Issue
  235. Line numbering in the VBE
  236. Shade all Blank rows in Range
  237. need help with VBA code for conditional formatting
  238. detecting open WB at start up
  239. Combine Workbooks based on Date
  240. Solved: Conditional Format of textbox on form
  241. Solved: Offset List Help
  242. Solved: PivotTable Finding x,y First Non-Blank Cell in Row Returning Column #
  243. Solved: Copy a range from 1 workbook to another workbook
  244. Solved: Add to a Year if not formated as a number
  245. Vlookup if I don't know the name of the workbook
  246. Merge Data from 2 lists into 1 without duplicates
  247. Solved: Testing the Left Header
  248. Input Mask?
  249. Web query help
  250. Trying to make a loop to shorten my code