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

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