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

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