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: A Loop?
  2. Solved: New Member-Formula act within a range
  3. Solved: How to speed-up Macro?
  4. Solved: Blackjack
  5. Insert page break after each row that has a cell with a specified value
  6. Time difference
  7. Macros
  8. Solved: How Do I Write This Formula?
  9. How to retrieve the alphabets of a word
  10. Conditional count (two conditions)
  11. Solved: Vlook up..?
  12. Conditional formatting
  13. Solved: Checking For Data In A Cell
  14. Solved: Why Doesn?t This INDIRECT Work?
  15. view hyperlink on a userform
  16. Location Change for a Chart
  17. Chart, mark value that varies
  18. Solved: Number Format
  19. Userform?
  20. Print area...
  21. Solved: What does this Dim mean?
  22. Merging-Copy Row-Marking Solved...
  23. comparing....
  24. Print "Repeat rows from bottom of worksheet"
  25. Solved: Combo Box help....
  26. Copying and pasting rows based on criteria in saved a list
  27. Solved: Test for Null in Listbox Value
  28. Protecting coding
  29. Line chart
  30. Modeless Userform to act like "Find and Replace" modeless form
  31. Solved: ToolTip for VBA checkbox in Excel
  32. Repeating search
  33. Solved: Not displaying N/A but showing a blank ""
  34. Solved: Qanalys - Quantitative analys of Manuscripts
  35. Conditionally format a cell the same as another cell upon a match
  36. Solved: Problems with ?MERGE? and ?xlCenterAcrossSelection?
  37. Solved: How to create a DLL via VBA editor?
  38. check for hyperlink
  39. Solved: Linking columns in different tabs of the same file
  40. Solved: treeview in worksheet
  41. Insert a new row after a certain number of rows
  42. Solved: Delete Duplicate Rows based on multiple columns
  43. Solved: Add NETWORKDAYS to a date
  44. Changing data selected in a UserForm
  45. Compare between two lists project
  46. [SOLVED:] Copy and Paste Error between Application instances
  47. Solved: Importing Non English Text
  48. Calculate thru VBA
  49. Solved: Deleting Row if word ends in "a" in column A?
  50. Sharing Macros
  51. Solved: About Windows Media Player on UserForm
  52. Solved: Excel to word at position
  53. Solved: Save only one sheet
  54. Solved: Macro Calling
  55. Solved: Copying rows into worksheet - problem with macro
  56. Solved: Excel Error Lists...?
  57. Solved: Complete Data Entry Before Close
  58. combobox
  59. Calculate period of time, excluding non-working hours
  60. Solved: Saving to various sections on the same sheet
  61. Excel VBA to Script
  62. Running/storing macros independently of worksheet
  63. A Simple search
  64. Solved: Password sensitivity
  65. Solved: Saving as xlExcel5 from Excel 2000
  66. Transfering information
  67. Solved: Help with VBA
  68. Application.Ready
  69. Solved: Modify Personal.xls Not Trusted Error
  70. SOLVED: How do you create a worksheet with a given name?
  71. count a numberformat
  72. ?Can?t Find Project or Library?
  73. Quick few questions
  74. Solved: How to sort worksheets?
  75. Copy worksheets to new workbook - Teach Me?
  76. Solved: Auto completion of Dates
  77. Sleeper: Landscape if 2 pages wide?
  78. List of last date sold and price
  79. hyperlinking to a macro?
  80. Solved: Copy/Paste within a Macro
  81. Solved: Format cells in noncontiguous selected rows
  82. Auto Transfer
  83. Solved: Delete empty rows and copy to another worksheet
  84. Excel Functions in VBA
  85. Solved: Unprotecting All Worksheets While Macro RUNS
  86. Solved: Problem with array
  87. Move files between directories
  88. Windows and Mac difference...Code wise
  89. How to get all texts from clipboard?
  90. Solved: Macro for Custom Formatting
  91. find and move data macro
  92. Solved: How to Assign ?Define Name? to a Button on a Toolbar
  93. Solved: Stop the cursor in a loop
  94. Solved: Opening a Word document from Excel in the running instance of Word
  95. Solved: Page break after each new customer
  96. Excel Range Math - anyone have a lookup?
  97. Forcing printer to print landscape
  98. Solved: CSV FILE
  99. VBA Cell locked
  100. Solved: Probem with comparing list code.
  101. Protect/Unprotect Closed workbook
  102. Solved: Select sheet based a combobox value
  103. Solved: Complele Daily Entries before Closing Worksheet
  104. Fit To pages wide
  105. Solved: Don't allow Special Characters
  106. Solved: Change to column if more than one item is checked
  107. Solved: Upper/Lower Case
  108. Solved: Sheetprotection and Save dialog
  109. Max from a certain range
  110. Fctns LARGE & SMALL Don't Work in Cond Fmtting Formulas
  111. Solved: Assign VBA Variable from Excel Cell
  112. Solved: Select All and Unselect all
  113. Solved: Adding features to an excel worksheet
  114. How to highlight precedents of formula
  115. Solved: progress bar
  116. Calculate Date Difference excluding Weekend (Saturday & Sunday)
  117. Hide Rows based on variable
  118. Excel data format query
  119. Solved: Pivot table
  120. using inputbox
  121. Solved: ALL UPPER CASE FONTS
  122. Solved: Transform general format in time format
  123. Solved: Loop to check every row
  124. Text Boxes Won?t Stay Visible on Charts
  125. Solved: copy specific cells sheet1 into form sheet2
  126. Solved: REF TO A CELLS NAME
  127. Solved: Parent and Child workbook relationships
  128. Automation: EVT Logs to Excel
  129. Solved: Change focus or unload between forms
  130. Run macro on passw protected TAB
  131. Solved: Next cell any direction
  132. Solved: Difficult... Macro to search multiple workbooks for a match?
  133. Keypress on Datepicker
  134. Run .exe from VBA code
  135. Replace a tilde with the corresponding headword
  136. Solved: Deleting text boxes
  137. A problem with user defined data type
  138. Can someone help me solve this issue pls?
  139. Time question
  140. Solved: Solved:Totaly stuck
  141. email active sheet problems
  142. Solved: Find / FindNext question
  143. Paste Format
  144. How to use DoEvents in VBA
  145. Solved: I want to make code smaller and more optomized
  146. Solved: Form to change sheets
  147. Solved: Defining variable Ranges?
  148. Solved: Programmatically add controls
  149. Solved: Programmatically add controls 2
  150. Addin for work
  151. Names like McNeed etc.
  152. Solved: Programmatically add code to Workbook_Open
  153. stretch to a4
  154. sheetchange problem
  155. Solved: Looping Images
  156. Refresh Listbox
  157. Solved: Auto Tab
  158. right click menu in a text box
  159. Help Creating Pivot Table w/ Specific Consolidation Ranges
  160. Solved: Merge Cells
  161. DATA VALADATION
  162. Solved: Retrieve Data From A Database To Excel Using SQL
  163. [SOLVED:] Muliple Userforms
  164. Solved: Browse A Folder And Hyperlink All Modified WBs
  165. Sleeper: Auto-Adjust Ranking
  166. Don't have Frame1 & ListBox1 BackColor = fmBackStyleTransparent Property?
  167. Conditional Formatting for row based on cell
  168. How to return large multi-dimensional arrays from VBA Excel functions?
  169. combobox and listbox questions
  170. How does one obtain a folder name using VBA?
  171. Transparent Background Colour?
  172. Solved: VB Editor
  173. Solved: Timesheet calculation using forms accounting for sick days
  174. Cannot call "Format Cells" dialogue box - Excel Bug?
  175. Importing Data to a Form
  176. Solved: Delete specific rows from all spreadsheets
  177. Intelligent Copy Paste
  178. Clear:Temporary Internet Files + Opened Website Address Names + DNSCache+Cookies+Temp
  179. Solved: A Submit Button that Doesn?t
  180. Solved: Find named range that activecell is in
  181. Solved: get rid of duplications and data filtering!
  182. Execute macro on all sheets but last 6
  183. Solved: ToolTip for each item in combobox
  184. return text in one column based on another one
  185. Adding Cell reference as a header prior to print
  186. A Difficult thing indeed
  187. create a save as box in a user form
  188. Solved: Removing Controls on the Fly
  189. Solved: Preventing renaming sheets
  190. Solved: merge and print with offset
  191. Solved: Trouble with format of a textbox in a userform
  192. can't get rid of Bold
  193. Solved: Optimize Code
  194. VBA Code to Auto-Select Rows and Copy to New Worksheet
  195. Using Case Statement
  196. Solved: Problem with DB Path
  197. add a description
  198. Solved: Automatic Cell formating
  199. Solved: Clearing old data from a table
  200. Solved: Vlook up and two combo boxes
  201. Disable "shift" key
  202. Solved: quick question
  203. speedy page setup
  204. ComboBox - Using Combo Boxes to Change/Delete rows
  205. Solved: Help: Need to export image from Excel
  206. List Boxes
  207. Solved: Subscript Error
  208. Conditional code or format (No formula)
  209. Solved: Quantity at Operation based on In/Out marker
  210. auto update link from password protected file
  211. Paste format + formula attached to " Add new " Button
  212. Solved: Pop-up calendar confusion
  213. Solved: Data Entry Control
  214. Email sheet and cell reference
  215. Solved: Copy rows to 2 different workbooks
  216. Updating nested linked files
  217. test if more than one year
  218. Solved: Perl Conversion
  219. Solved: Check one range against another
  220. FileSystemObject and Subfolders
  221. Buttons Visible/Hidden
  222. Solved: Pop-up with list of sheets and checkboxes?
  223. User Selected Excel File
  224. Advice Needed
  225. Cut and Paste Rows to New Worksheet based on date in column - protected worksheet
  226. Set focus in a list box
  227. Solved: Duplicates removals!
  228. Solved: Help with Error Handling
  229. Solved: Removing Blanks
  230. Solved: Multiple instances of VBAProject
  231. Solved: From - Option Button & Focus issue
  232. extract data from notepad to xls
  233. Settings?
  234. Get Column Letter
  235. Extracting data from another file
  236. Solved: CSV File
  237. Solved: row counting, pasting on trigger
  238. Converting a Column Reference/Address to Points measurement for Shape alignment.
  239. Transfering data form to form
  240. Solved: click cell behind picture NOW EDITED
  241. Solved: Form Controls Vs Active X Controls
  242. Solved: Forcing a spreadsheet with a read only attribute to reopen as read/write
  243. Constant
  244. Solved: Syntax calculation error
  245. Solved: validation techniques
  246. VLookup on more than one column
  247. Conditional transfer of data
  248. [SOLVED:] How to display a special character in a message box?
  249. Solved: Userform updating worksheet incorrectly
  250. Clean way to create popup help balloons